looking up data/numbers in table
 

I have a table of numbers, i want to look up the left hand side vertical
number & then match another number from the top.. which give the result
number..
how are i do this?
i have tried VLOOKUP & HLOOKUP

looking up data/numbers in table
 

You'll want to use a combination of =index() and =match().

Debra Dalgleish has lots of notes he
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

Jazntails wrote:

I have a table of numbers, i want to look up the left hand side vertical
number & then match another number from the top.. which give the result
number..
how are i do this?
i have tried VLOOKUP & HLOOKUP

--

Dave Peterson

looking up data/numbers in table
 

I think you will need something like this:

=INDEX(B2:K10,MATCH(vert_item,A2:A10,0),MATCH(hori z_item,B1:K1,0))

where your data occupies A1:K10.

Hope this helps.

Pete

On Aug 18, 12:04*pm, Jazntails
wrote:
I have a table of numbers, i want to look up the left hand side vertical
number & then match another number from the top.. which give the result
number..
how are i do this?
i have tried VLOOKUP & HLOOKUP