#value!

  • Thread starter Thread starter Wu
  • Start date Start date
W

Wu

I have run a vlookup function, there are "#value!" shown on some cells.

How can I change these cells to blank, I dont want to show "#value!".
 
Wu said:
I have run a vlookup function, there are "#value!" shown on some cells.
How can I change these cells to blank, I dont want to show "#value!".
Click to expand...

Try trapping it with ISERROR, like this:
=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))

---
 
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

#VALUE! (ANY HELP) 1
Formatting 0 values to show blank cells 4
Newbie: Copying row of values to a column 4
Using COUNTA and excluding formulas that gives zero or blank cells 3
VLOOKUP Problem 1
#VALUE! ERROR 3
Vlookups and formats 3
Vlookup and Trace Return Cell 2

Back
Top