software

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.

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

Then use a vlookup formula with concatenated string.

e.g. =vlookup(A1amp;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 Nameamp;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: www.excelforum.com/member.php...oamp;userid=29182
View this thread: www.excelforum.com/showthread...hreadid=493887Top Drawer.

CheersOriginally Posted by VitoInsert a column before your lookup table and concatenate the name and
date columns. ie. =X1amp;Y1, assuming your table, after the new column
begins in X1.

Then use a vlookup formula with concatenated string.

e.g. =vlookup(A1amp;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 Nameamp;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: www.excelforum.com/member.php...oamp;userid=29182
View this thread: www.excelforum.com/showthread...hreadid=493887