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

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
---
"Jim" wrote:
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

Try this.

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

--
--------------------
(MS-Exl-Learner)
--------------------



"Jim" wrote:

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