iserr question

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I have the following formula
IF(N3="research","FMR",IF(N3="Sub Project",0,VLOOKUP
(N3,Balance,5,FALSE)))
My problem is the lookup table does not have every answer
and I get the #NA result. I know that in that case the
result is 0. How do I modify this formula to change #na to
0 ?
TIA
ray
 
Hi Ray,
IF(N3="research","FMR",IF(N3="Sub Project",0, if(isna(VLOOKUP
(N3,Balance,5,FALSE)),0,VLOOKUP (N3,Balance,5,FALSE)))

I am standing at a cimputer proctoring an exam so you will need to cj\ehck
placement of ( ) in that.
Bernard
 
Back
Top