Thread
:
Two dimensional look up
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
Two dimensional look up
One way...
Assume you're table is in the range A1:E5
Lookup values:
A10 = maths
B10 = Joe
=VLOOKUP(A10,A1:E5,MATCH(B10,A1:E1,0),0)
--
Biff
Microsoft Excel MVP
"2 D lookup" <2 D
wrote in message
...
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.
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko