View Single Post
  #1   Report Post  
stevenpwhite stevenpwhite is offline
Junior Member
 
Posts: 3
Question 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.