Vlookup help

Hi, 

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)

 

TABLE:

M                                  N                           O          P

COMPUWARE CORP65 | COMPUWARE CORP | 65 | AB987654

By: Muneeb

Leave a Reply

Your email address will not be published. Required fields are marked *