one way:

=VLOOKUP(J10,A:B,2,FALSE)


where J10 is the cell you enter your value into.


In article ,
"Mark Scott" wrote:

I was looking at VLOOKUP and HLOOKUP but I dont think they do what I am
wanting.

What I need to do is to put in numbers into a sheet and then bring back a
reference that a certain number is tied to fom a table on another part of
the sheet: ie if the table is:

255 nnnnnnnn
254 nnnnnnnh
252 nnnnnnhh

then when I type in 254 into a cell I would like a function to return
nnnnnnhh into another cell. I tried usinf nested IF but there are to many
arguements.

Is this possible?

Regards

Mark