Thread: Array lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j0rg3a1b3rt0 j0rg3a1b3rt0 is offline
external usenet poster
 
Posts: 1
Default 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?