View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
2 D lookup 2 D lookup is offline
external usenet poster
 
Posts: 1
Default Two dimensional look up

HI,
I am looking for a function which returns a value by looking in to 2
dimensional table.For example
Joe Mike Sandy Andy
Maths 10 35 10 35
Science 20 65 20 65
Trignomtry 30 98 30 98
Eenglish 40 65 40 65

If I pass Joe and Maths as two inputs to fuction,it should give me 10.
I was using round about methods using IF conditions and LOOKUP functions.
Butif the number of of columns and rows are huge,its not a practical solution.

Can you please suggest me a practical solution which I cam implement for
looking in to huge tables containing like 100 rows and 100 columns.

THanks in advance.