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.

Attached Images

	Sheet 1.JPG (29.4 KB, 23 views)
	Sheet 2.JPG (41.6 KB, 23 views)

Please post a sample sheet. It's much easier to work with than an image

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here is the sample file for the situation I'm talking about.

Thanks

Attached Files

Sample Workbook.xls (27.0 KB, 14 views)

Maybe like this.

Attached Files

Lfisc.xlsx (13.7 KB, 17 views)

Thanks, that doesn't quite work for me. I need to match with the description.

Perhaps

=INDEX(Sheet2!$B$2:$B$7;MATCH("*"&D2&"*";Sheet2!$C $2:$C$7;0))
(replace semi-colons with commas if need be)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post