Lookup

E

Ed

Hello, how can I do this? I have a sheet where I have on the x-axis all the
weeks and on the y-axis the item codes, there are specific values
corresponding for each X and Y... how can I set a function to look up for a
value matching a certain week on X and a certain code on Y? but not knowing
in which column or row the value will be?? For example the value for item 5.4
on week 11?

,thank you
 
G

galimi

The offset command can be used to return the data you want.
=offset(reference,row_offset, column_offset,height, width)

Reference will be the upper left hand corner starting point of your matrix,
essentially one left of the week and above the item. Row offset can use a
combination of the match & index functions to find the proper row, with the
same combination for column_offset. The height & width are going to both be
1 since you are returning one cell.
 
Top