Multiple lookup values

[jmartin]

Hey, guys. I'm new here but I've been lurking for a while. I'm having a problem I hope you can help with.

Below is the image of the setup of my sheet. I'm accepting input from the user is cells H2,H3, and H4. I'm looking for an in-cell formula (for H6) that will pull the numbers from the appropriate column based on the employee name (H4) and the date range (H2:H3).

I promise you I've done the best that I could. Here's where I've been:

=SUM(VLOOKUP(A30,A1:E26,COLUMN(INDEX(1:1,MATCH(A31,1:1,0)))))

With this I couldn't figure out how to do multiple lookup_values for VLOOKUP.

=SUM(IF(($A$2:$A$26>=$G$13)*($A$2:$A$26<=$G$14),C2:C26,0))

With this I couldn't figure out how to get it to look in the right column based on the employee name.

I've tried a few other things but these are my least embarrassing I'm not sure what else to try. Anyone have any suggestions? The only thing to keep in mind is that column A will not necessarily always be in chronological order.

 

[salahmost]

If I got you right ...according to your data use:

=SUMPRODUCT(($A$2:$A$26>=$H$1)*($A$2:$A$26<=$H$2)*(INDEX($A$2:$D$26,,MATCH(H4,A1:D1,0))))

ـــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ
Salah

 

[jmartin]

Dude, this worked perfectly. Thanks for your help.