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