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)
 
You must log in or register to reply here.

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

Similar Threads

Multiple IF Statement 2
VLookup not working - missing entries or not returning correct values 1
Can't Explain N/A in Vlookup 2
VLOOKUP forumla for Excel HELP! 1
VLookup help, or similar function help, Please! 2
Looking for IF with VLOOKUP statement with two conditions. 6
Using vlookup to populate multiple rows at once 5
Using Parsed String Results in VLOOKUP 2

Back
Top