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
|