#N/A
 

How can I hide the #N/A results on formulas that are showing up on my
spreadsheets. The results that I am getting are tied into VLOOKUP, and I
have to use this function to complete the multiple needs for this report. If
the respective line does not apply at that given time I get the #N/A result.
I would rather the cell remain "empty". I have looked at all of the
suggestions, but nothing appears to be working for me...HELP

#N/A
 

=IF(ISNA(your_formula),"",your_formula)
--
Gary''s Student - gsnu200838

#N/A
 

=IF(ISNA(YOUR_FORMULA),"",(YOUR_FORMULA))

this should help.


"Ken" wrote in message
...
How can I hide the #N/A results on formulas that are showing up on my
spreadsheets. The results that I am getting are tied into VLOOKUP, and I
have to use this function to complete the multiple needs for this report.
If
the respective line does not apply at that given time I get the #N/A
result.
I would rather the cell remain "empty". I have looked at all of the
suggestions, but nothing appears to be working for me...HELP

#N/A
 

Leave the VB in the box

=MAX(IF(A2:A23=C2,B2:B23))

with the Co you are looking for in C2. Change MAX to MIN to achieve to obvious

'This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike
"Ken" wrote:

How can I hide the #N/A results on formulas that are showing up on my
spreadsheets. The results that I am getting are tied into VLOOKUP, and I
have to use this function to complete the multiple needs for this report. If
the respective line does not apply at that given time I get the #N/A result.
I would rather the cell remain "empty". I have looked at all of the
suggestions, but nothing appears to be working for me...HELP

I use If and Isna:
IF(ISNA(VLOOKUP(a:a,Sheet1!A:F,4,FALSE)),"",VLOOKU P(a:a,Sheet1!A:F,4,FALSE))