MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF function with the VLOOKUP function


Posted by MERCI on September 03, 2001 12:18 AM

Hi,

I have a problem! I wanna use the "IF" function with the "VLOOKUP" function on "Sheets2"! That If Vlookup ... didn't found any result that "Sheets1" Cell "E10" says "Nothing Found" but I don't know how to do this! How do I do this? Hope someone can help me! Thanks!

MERCI


Posted by Juan Pablo on September 03, 2001 8:08 AM

How about this ?

=IF(ISNA(VLOOKUP(...)),"Nothing Found",VLOOKUP(...))

Juan Pablo

Posted by Rob Jackson on September 03, 2001 8:11 AM

You need to use:
=IF(ISNA(VLOOKUP(......)),"Nothing Found",VLOOKUP(....))
Its a bit coarse and would be improved by taking the VLOOKUP out to another cell, but that's optional.

Rob