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