Another VLOOKUP question (multiple criteria)

[kmarch3]

I've searched endlessly for a solution for this and just havent been able to come across one. Maybe you guys can help..

The problem that i am having is populating ONE cell with a value that matches 3 conditions using VLOOKUP or something else.

Ive attached a spreadsheet, sorry about all the arrows but ill explain anything if you have questions.

the table on the left is constant and never changes other than the date and sum amount values, while the table on the right is replaced every month and all i want from it is the sum(amt) values that match those 3 criteria from the table on the left.

there are multiple tables to this but i have only created one, right now i am doing this manually where i paste the value from the table on the right to the table on the left, one by one

Ive tried INDEX and MATCH too but i just cant get it to work for 3 columns like i need


any input would help please

[Andrew-R]

In T2 try:

=IFERROR(INDEX($J$1:$J$25,MAX(INDEX(ROW($C$1:$C$25)*($C$1:$C$25=M2)*($D$1:$D$25=N2)*($I$1:$I$25=S2),0))),"Not found")

And drag down.

[kmarch3]

This is actually the opposite of what I need. I want to take the cell values FROM column T and have it populate column J. This formula will still work for that right?

[Haseeb Avarakkan]

Try this in K2 with CTRL+SHIFT+ENTER,

Please Login or Register  to view this content.

then copy to other cells.