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