Find a specific text and vlookup

[oozden]

I have 2 seperate tables on the attached file. I would like to get "white" quantities from table2 to table1 for x,y,z columns. I am working on two huge worksheet with hundreds of rows. So I need to find the right answer with some "IF" and "vlookup" formulas I think.

[alvin-chung]

Hi oozden, is this what you're looking for?

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[AL1976]

hi,
in C5: =SUMPRODUCT(($H$5:$H$11=B5)*($I$5:$I$11="white")*$J$5:$J$11)
drag to C6 and C7.
rgds,
AL

[oozden]

Hi oozden, is this what you're looking for?

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Thanks mate. This one worked perfectly for me.

@AL1976, thank you for your help too.

[alvin-chung]

You're welcome, thanks for the reputation


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin