Maybe...

=IF(ISERROR(VLOOKUP($C$9,'sheet5'!$N$1:$Q$8,2,FALS E)),"",VLOOKUP($C$9,'sheet5'!$N$1:$Q$8,2,FALSE))


shikamikamoomoo Wrote:
I'm using the VLOOKUP function and would like the cells that are FALSE
to be blank instead of produce the #N/A value. I've read several posts
asking similar questions, but I cannot get it to work....

My formula:

=IF($C$9="","",VLOOKUP($C$9,'sheet5'!$N$1:$Q$8,2,F ALSE))

I've seen that people say to put 'ISNA', but I must be putting it in
the wrong place because I can't get it to work. If someone could
please spell it out for me I would greatly appreciate it! As it is
right now I am doing paste special and then search and replace....it's
a real hassle ;)

Thanks for any help you can offer!


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=396288