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

## Bookmarks