Stopping display of "FALSE"

  • Thread starter Thread starter vinnie123
  • Start date Start date
V

vinnie123

I'm sure it is a really straightforward problem.

I have a sheet with a lot of data generated form formulas, mainly
VLOOKUP and IF with output being whole numbers. How can I stop the word
"FALSE" from appearing in cells with no valid data, just leaving those
cells blank.

Regards, Vinnie.
 
Normally, you add an additional IF to your formula, to test for this condition.

Something like =IF(A1="","",A1*B1)
=IF(A1="","",VLOOKUP(A1,Sheet2!A1:D250,3,FALSE)
or something to that effect. It all depends on what it is you want to block
out. I suggest you post your VLOOKUP formula, then we can assist you.
 
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

not displaying "FALSE" in cells 2
Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ? 3
Blank Cell 5
What am I doing wrong 14
Data displayed that is not equal to FALSE in a row 3
=IF(Input_Sheet!D52="","",Input_Sheet!D52) 2
#N/A 5
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0

Back
Top