Array lookup
Hi, this is my situation. I have a table that I would like to find in the top
row the value given two situation, well let me give you an example:
30 45 60 75
Apple 4 3 2 1
Orange 5 2 3 4
Banana 2 4 3 1
The thing is, if I use Orange and 2 as default, I want to be able to obtain
45. Which formula I need to use?
|