Combining lookup with matrix

Hi all,

 

I’m looking for a solution to my excel problem. I’m not sure whether this can be done by using formulas solely, I hope it can be done as I do not have experience with vba.

 

My issue:

I have a sheet of data consisting of a fixed range of rows per product group, however the possibility is present that next month another product group will be added by the system in the middle of the file (it’s sorted alphabetically), shifting the whole file. 

What I would like to do is to create some kind of formula that FIRST seeks the specific product group using its unique product code, and from that number taking the 20th row and the 20th column to show the value in that cell.

By: Jelle Berentsen

Leave a Reply

Your email address will not be published. Required fields are marked *