or

=VLOOKUP(B2,Sheet2!A2:B940,1,FALSE)

"Alan" <[email protected]> wrote in message news:...
> =vlookup(b2,'sheet2,a2:b940,1,false)
>
> Try
>
> =VLOOKUP(B2,Sheet2!A2:B490,1,FALSE)
>
> Post back if that doesnt work,
> Regards,
> Alan.
> "JPriest" <[email protected]> wrote in
> message news:[email protected]...
>>
>> So i'm attempting this one more time because i haven't been able to get
>> it to work for me yet.
>>
>> Here's the situation:
>>
>> I want to find the value in sheet1b2 in sheet2 col b and return the
>> value in sheet2 col a to an empty cell in sheet 1
>>
>> here's the formula i have tried and gotten an NA# error
>> =vlookup(b2,'sheet2,a2:b940,1,false) I have also changed false to true.
>> This formula i've gotten from the excel help file and doesn't work for
>> me.
>>
>> Can someone please help??!
>>
>> Thanks in advance,
>> Jeff
>>
>>
>> --
>> JPriest
>> ------------------------------------------------------------------------
>> JPriest's Profile:
>> http://www.excelforum.com/member.php...o&userid=24695
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=400874
>>

>
>