Prev: Nonadjacent columns
Next: How do i change category names in a drop down list in excel?
From: Hamed parhizkar on 2 Feb 2010 18:14
Can you have two vlookups in one statement? Tab A has 3 columns, EMP #, GROSS
PAY, and DATE.

See the chart below. Say i want to a cell to tell me the gross pay of emp
#1550 on 01/22/10, how would the formula be?

EMP# GROSS PAY DATE
1550 $1000 01/08/10
1582 $1530 01/22/10
1550 $1643 01/22/10

From: Pete_UK on 2 Feb 2010 18:49
Assuming your data with headings is in A1:C4, and that you use cell E2
for the employer number (1550) and F2 for the date (01/22/10), then
you could put this formula in G2:

=SUMPRODUCT((A$2:A$4=E2)*(C$2:C$4=F2),B$2:B$4)

to return 1643. Adjust the ranges to suit your data.

Hope this helps.

Pete

On Feb 2, 11:14 pm, Hamed parhizkar
<Hamedparhiz...(a)discussions.microsoft.com> wrote:
> Can you have two vlookups in one statement? Tab A has 3 columns, EMP #, GROSS
> PAY, and DATE.
>
> See the chart below. Say i want to a cell to tell me the gross pay of emp
> #1550 on 01/22/10, how would the formula be?
>
> EMP#    GROSS PAY   DATE
> 1550      $1000          01/08/10
> 1582      $1530          01/22/10
> 1550      $1643          01/22/10

 | 
Pages: 1
Prev: Nonadjacent columns
Next: How do i change category names in a drop down list in excel?