C
comotoman
When i have formulas with there criteria not fullfilled, i get th
"#N/A". How do i get that to go away
"#N/A". How do i get that to go away
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BenjieLop
comotoman said:When i have formulas with there criteria not fullfilled, i get th
"#N/A". How do i get that to go away?
One way ...
=IF(ISERROR(YOUR_FORMULA),\" \",YOUR_FORMULA
will take care of this problem of yours.
Regards
M
MDOTJR
you still have an error on your formula...so you kno
C
comotoman
=if(iserror(VLOOKUP(A9,$C$154:$G$680,2,FALSE),
",VLOOKUP(A9,$C$154:$G$680,2,FALSE)))
i get an error message base on the "
",VLOOKUP(A9,$C$154:$G$680,2,FALSE)))
i get an error message base on the "
C
comotoman
Please Help!!
A
Alan
Thats
=IF(ISERROR(VLOOKUP(A9,$C$154:$G$680,2,FALSE)),"",VLOOKUP(A9,$C$154:$G$680,2,FALSE))
=IF(ISERROR(VLOOKUP(A9,$C$154:$G$680,2,FALSE)),"",VLOOKUP(A9,$C$154:$G$680,2,FALSE))
C
comotoman
That did the trick, thank you all for the help
A
Alan
Youre welcome,
Alan.
Alan.