#na error

Brian · Oct 20, 2004

Hello,

What do I add to the following formula in order to prevent the #NA! error
message?

=vlookup(c6,H:I,2,false)

Thank You
Brian

Myrna Larson · Oct 20, 2004

=IF(ISNA(VLOOKUP(C6,H:I,2,FALSE)),"",VLOOKUP(C6,H:I,2,FALSE))