IsError help


J

Jim

Good morning Excel Masters,

Quick question - how do I write the following so that it returns a blank
cell if the cell it is referencing is blank?

=VLOOKUP(F2,[Vehicle_Data.xls]Master_Sales_Lookup!$B$2:$J$89,2,FALSE)

Right now I get a #N/A

Thanks
 
Ad

Advertisements

Ad

Advertisements

M

MS-Exl-Learner

Try this.

=IF(ISNA(VLOOKUP(F2,[Vehicle_Data.xls]Master_Sales_Lookup!$B$2:$J$89,2,FALSE)),"",VLOOKUP(F2,[Vehicle_Data.xls]Master_Sales_Lookup!$B$2:$J$89,2,FALSE))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top