#N/A

[Ken]

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

 

[Gary''s Student]

=IF(ISNA(your_formula),"",your_formula)

 

[Gaurav]

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

this should help.

 

[Mike H]

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

 

[begrry]

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