IsError help

[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

 

[Max]

One simple way which might suffice:
=IF(F2="","",yourvlookup)
any good? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[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))

 

[p45cal]

in the same vein

if(ISBLANK(F2),"",yourlookup