I’m trying to do a vlookup to find a cusip (column P) in TABLE, however since (column M) doesn’t match with (A2 & B2) value, has the word Corp in – it gives me an error. What’s the best way to do a cusip lookup for this example? Any other function in excel?
A2 B2 C2
Credit Facility CUSIP
Compuware 65 =VLOOKUP(A2&B2,TABLE!M:P,4,FALSE)
M N O P
COMPUWARE CORP65 | COMPUWARE CORP | 65 | AB987654