Vlookup or match (Excel 2000)

Topic

New Reply

I want the formula to lookup/compare the text. If the text is in the lookup table, return the text. If it is not return a blank not an error message. Thank you.
=(VLOOKUP(N3,’Billing Codes.xls’!$A$3:$A$78,1))

Reply | Quote

Replies

Try this:

=IF(ISNA(VLOOKUP(N3,'Billing Codes.xls'!$A$3:$A$78,1)),"",VLOOKUP(N3,'Billing Codes.xls'!$A$3:$A$78,1))

Reply | Quote

I tweeked it just a bit. Thank you.
=IF(ISERROR(VLOOKUP(N3, ‘Billing Codes’!A$1:$A$76,1,FALSE)),””,VLOOKUP(N3, ‘Billing Codes’!$A$1:$A$76,1,FALSE))

Reply | Quote