Lookup (multiple variables)
I have two worksheets. On one a name, date and amount (thousands of records). The other is a small sample containing just a name and date which i require to match to records in the first sheet and return the amount.
The are many duplicates of the name with various dates, so i need name AND date to match for amount to be returned.
Help! This is far beyond my puny Excell powers.
|