VLOOKUP with 2 worksheets and a partial value
I need assistance setting up a VLOOKUP for a worksheet I'm working on.
Sheet 1 lists payments from different companies. The description column represents a check number or deposit number. The only thing missing is the date those payments were received. Sheet 2 shows what was deposited in a bank account. The check amount would be one value I could use for matching, but it's not reliable because there could be duplicates. The value I want to match is the "description" value. The description value from Sheet 1 can be found on Sheet 2, but it's only a part of the full description on Sheet 2.
Please see attachments for sample worksheets. Is there a way to do what I need to do? Also, please let me know if this is not clear enough.
|