Hi there!

I have Spreadsheet 1 and Spreadsheet 2 with the same information but
Spreadsheet 2 is missing the 'Vendor Name' information that I need.
Spreadsheet 1 may also not contain the same number of rows that are in
Spreadsheet 2 but for now its' the only spreadsheet I have to look for
matching Vendor Names.

I want to use Spreadsheet 1 to find the Vendor Name based on looking at it's
related columns: Last Name, First Name and Invoice Number and Cheque Amount
and fill Spreadsheet 1 column C with the missing information.

Spreadsheet 1:

A B C
D
1 Last Name, First Name Invoice Number Vendor Name Cheque
Amount
2 Ander, Joe 10000 Smith
Enterprises 3500.00
3 Doe, Fawn 22 Lavender
Corp. 1100.00
4 Johnson, Andrew D90304-1 Lavender Corp.
200.00
4 Taylor, Tyler 0000040 Taylor & Sons
60.00
5 Smith, John 100004 Smith
Enterprises 540.00

Spreadsheet 2
A B C
D
1 Last Name, First Name Invoice Number Vendor Name Cheque
Amount
2 Taylor, Tyler 0000040
60.00
3 Smith, John 10000
3500.00
3 Lavender, Lila D90304-1
200.00
4 Lavender, Lila E90405-1
75.00



I have sorted both spreadsheets by column A.

The problem that I think might heed any simple solution is that a vendor
name can have different names related to it from column A with different
cheque amounts in column D, that is why I want to look at column A,B,D for a
match to fill in C.

I am not familiar with using macros so if there is a formula I could use,
any help is greatly greatly appreciated. :)