Hi - I'm trying to compare two sets of data by looking up a value that only partially matches: for instance:

In the first data set, the account is named "Production:Melchior Productions LLC:1A-Melchior Production Expenses:003A_Architect" with a value of $XX

In the second data set, the account is named "003A_Architect" with a value of $XX

I want to compare the two account values (they should both be the same value), but obviously can't use a vlookup because the account name is not an exact match.

Any thoughts??