replace N/A by a blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i replace a #N/A that I get sometimes in a Vlookup by A blank ? or
the value if eveything is fine

TKS
 
One way:


=IF(ISNA(MATCH(A1,Sheet2!A:A,FALSE)),"",VLOOKUP(A1,Sheet2!A:B,2,FALSE)
 
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

If condition not met get #N/A 5
Vlookup with no #N/A? 5
Please help on formula that will not work (If-And formula) 3
Vlookup - N/A 4
#N/A 5
VLOOKUP problem 3
Replace #N/A with 0 1
#N/A Conditional Formatting affects all cells? 9

Back
Top