I have tried everything & I keep getting #n/a returned in my vlookup formula.
I have tried IF and ISNA and they do not work. I know the formula is correct.
Plese help!

=VLOOKUP(B16,Sheet1!B:F,5,FALSE)
=IF(ISNA(VLOOKUP(B16,Sheet1!B:F,5,FALSE))=TRUE,"Te st",VLOOKUP(B16,Sheet1!B:F,5,FALSE)) Note: I just get test returned
=IF(B16="","",VLOOKUP(B16,Sheet1!B:F,5,FALSE))