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