Look up list of values that matched two categories

Hi Guys,
Need your help here. i have here two sheets ( result, and data bank). in sheet databank i have 3 columns (value,color,shape).
In sheet RESULT, B8:B11 i want to get the list of all the VALUE from data bank that matched my categories in A2 and A3.

PLEASE SEE ATTACHED EXCEL FILE FOR REFERENCE.

THANK YOU VERY MUCH.

Try

B8

Formula:

Please Login or Register  to view this content.

Copy down!

Or can use pivot table
see the attached file

Hi samba.

I need the formula to be placed in the sheet "RESULT". WHEREIN B2 and B3 ARE subject to drop down list.
so if ill change B2 FROM red to pink B3 from heart to triangle, A8:A18 should list down the values with those criteria.


thank you

if you want formula solution then its ok in pivot table also you can get the same result by changing the red to blue and heart to trangle from dropdown

Hi there Samba,

Can you explain what is the use of *10^10?

This is for manipulating the TURE value into Largest numbers