if statement involving text

[Guest]

in my project i compare two columns using vlookups and get a number of #N/A.
i am trying to come up with an if statement where if i have #N/A, i want a
return of 0, but if not i want the return of the value in another cell in a
field called "status". the field "Status" says "open", "closed" or other.i
tried general functiosn such as
=IF(B3=#N/A,0,H3) where col B contains the result of the vlookup (#N/A or
the value i was looking for), and col H contains status in text. the formula
i came up with didnt help, returns #N/A.

thx

 

[Guest]

you would use isna such as
=IF(ISNA(VLOOKUP(B1,Sheet2!A1:C18,2,FALSE)),0,VLOOKUP(B1,Sheet2!A1:C18,2,FALSE))

 

[Guest]

=IF(ISNA(B3),0,H3)