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.

Lookup (multiple variables)
 

Insert a column before your lookup table and concatenate the name and
date columns. ie. =X1&Y1, assuming your table, after the new column
begins in X1.

Then use a vlookup formula with concatenated string.

e.g. =vlookup(A1&B1,$W$1:$Y$100,3,0), Where A1 contains the name to
lookup and B1 contains the corresponding date to lookup, W1:Y100 is
the lookup table with column W containing the concatenated Name&Date
columns. Change references and ranges to match your situation. Then
copy down the formulas.

You can always hide column W.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=493887

Top Drawer.

Cheers