Find Value If Multi Criteria Matches Index

Hi,

Basically I am trying to find from a table the value corresponding to two criteria matches.

For instance, I have 3 products (jeans, shirts, shoes) and they have matching brands. I have to return the cost or code for the corresponding Jeans and Brand. Although, Im having a hard time doing this. Ive tried Index Match Find Vlookups and Ifs, but i am doing something wrong.

Please help!!!
Thnks

Originally Posted by davesexcel

Check this out
http://www.contextures.com/xlFunctio...ml#IndexMatch4

Those examples are great, but Im a still having one problem.

I have to retrieve more than one column values from 2 multiple criteria matches.
Can you help?
What I mean is a way to input only full table to return from column 1 or 2 or 3 or etc... Instead of changing the array everytime. Somehow following this line of thought, code a worksheet_change to offset the results.

Originally Posted by davesexcel

I am not sure what you mean,
This is the formula for the example you provided.

Please Login or Register  to view this content.

I got it straight from the link in my previous post.

That works fine, except when I have tons of columns and I need to retrieve data automatically by with Private Sub Worksheet_Change.
Any Ideas?

ie: Using ",MATCH(B5,Table!$A$2:$A$12,0),MATCH(C5,Table!$B$2:$B$12,0))" as Target.Row?? and OFFSET something like that

Any ideas someone??