looking up data/numbers in table

[Jazntails]

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]

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

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

 

[Pete_UK]

I think you will need something like this:

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

where your data occupies A1:K10.

Hope this helps.

Pete