A
abakay
Hi everyone:
Here are two spreadsheets:
Spreadsheet 1
ID Donations Date
01 100 01/04
02 300 03/05
02 500 03/06
03 90 04/05
04 600 03/05
04 400 02/03
Spreadsheet 2
ID Age at Donation date
01 28
02 36
02 37
03 28
04 30
04 28
My Question is how can I use a vlookup (or other) to associate individual
donors to their donation and the corresponding age when the donation occur.
Vlookup picks up the first matching data when one use the ID AS THE LOOKUP
VALUE.
Any help will be greatly appreciated!
Thank you.
Here are two spreadsheets:
Spreadsheet 1
ID Donations Date
01 100 01/04
02 300 03/05
02 500 03/06
03 90 04/05
04 600 03/05
04 400 02/03
Spreadsheet 2
ID Age at Donation date
01 28
02 36
02 37
03 28
04 30
04 28
My Question is how can I use a vlookup (or other) to associate individual
donors to their donation and the corresponding age when the donation occur.
Vlookup picks up the first matching data when one use the ID AS THE LOOKUP
VALUE.
Any help will be greatly appreciated!
Thank you.