Lookup (multiple variables)

S

stevenpwhite

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.
 
V

Vito

Insert a column before your lookup table and concatenate the name an
date columns. ie. =X1&Y1, assuming your table, after the new colum
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 t
lookup and B1 contains the corresponding date to lookup, W1:Y100 i
the lookup table with column W containing the concatenated Name&Dat
columns. Change references and ranges to match your situation. The
copy down the formulas.

You can always hide column W
 
S

stevenpwhite

Top Drawer.

Cheers
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?action=getinfo&userid=29182
View this thread:
http://www.excelforum.com/showthread.php?threadid=493887
Click to expand...
 
Top