Lookup Function?

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

one way:

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


where J10 is the cell you enter your value into.


In article <Iu3fe.42113$qK3.15044@fe1.news.blueyonder.co.uk>,
"Mark Scott" <mark-scott@blueyonder.co.uk> 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

Thanks, that did the trick.

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-7A6E74.07472007052005@msnews.microsoft.com...
> one way:
>
> =VLOOKUP(J10,A:B,2,FALSE)
>
>
> where J10 is the cell you enter your value into.
>
>
> In article <Iu3fe.42113$qK3.15044@fe1.news.blueyonder.co.uk>,
> "Mark Scott" <mark-scott@blueyonder.co.uk> 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