Vlookup

  • Thread starter Thread starter shaun collier
  • Start date Start date
S

shaun collier

Hi guys,
Sussed out how to work vlookup. However when the source cell is nil 'hash
N/A'shows. I then have delete the unused vlookups to make printed document
look acceptable. Is there a way to make an emty cell appear when the source
cell is empty?
Regards
Shaun
 
Hi Shaun

try wrapping it in an IF statements. Assuming your source cell was A1,
then
=IF(A1="","",yourvlookup_formula)
 
Back
Top