Lookup
 

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

Lookup
 

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.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Ed" wrote:

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