Lookup (multiple variables)

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


--
stevenpwhite

[Vito]

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.

[stevenpwhite]

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


--
stevenpwhite