Lookup (multiple variables)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stevenpwhite - 15 Dec 2005 14:43 GMT

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.

Signature

stevenpwhite

Reply to this Message

Vito - 15 Dec 2005 19:21 GMT

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

Reply to this Message

stevenpwhite - 16 Dec 2005 11:03 GMT

Top Drawer.

Cheers

Vito Wrote:

> Insert a column before your lookup table and concatenate the name and
> date columns. ie. =X1&Y1, assuming your table, after the new column
[quoted text clipped - 17 lines]
> View this thread:
> http://www.excelforum.com/showthread.php?threadid=493887

Signature

stevenpwhite

Reply to this Message