Multi Criteria Match Problem ...

[Russ At Index]

Hello , out in the Greater Excel World ,

Once again i find myself reaching out for some kind assistance on a project .

Overview being i want to populate a spreadsheet with a specific number that relates to all the criteria held in both spreadsheets, so here goes with my
explanation .

Sheet1 Cells have :
A10 - Type
B10 - Level
C10 - Bay
E6 - Aisle
My answer will sit in cell E10 & be copied to populate the data in sheet 1

Sheet2 has a table which following data sits :
Column A - Type
Column B - Aisle
Column C - Bay
Column D - Level
Column G - Contains the number which i need to populate E6 with in sheet 1

Any solution would be greatly appreciated ,

Stay safe ,

Russ.

 

[Russ At Index]

Hi Peter ,

Thank you for your kind assistance , i will try the formula in due course & let you know the outcome,

Many thanks ,

Russ.

Hi Peter ,
Thank you very much , your formula works perfectly , i am most grateful.

Have a good evening ,

Russ.

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.

 

[Russ At Index]

Afternoon Peter ,
Forgive the late reply , i was convinced i had contacted you to say thank you , your formula works just as i wanted .

Would there be a way to add the same formula criteria to the one below , but to look at another table ?. So in effect one line of
formula would be as below , the other ( the added formula ) would look at another table with a different description than Visits.

=INDEX(FILTER(TableVisits[[Visits]:[Visits]],(TableVisits[[Type]:[Type]]=$A10)*(TableVisits[[Aisle]:[Aisle]]=E$6)*(TableVisits[[Bay]:[Bay]]=$C10)*(TableVisits[[Level]:[Level]]=$B10),""),1)

Regards ,

Stay safe , Russ.

 

[Peter_SSs]

i was convinced i had contacted you to say thank you , your formula works just as i wanted .

You did - in post #11 above.

I don't understand your new request so if you still need help with that you will need to spell it out in more detail.

 

[Russ At Index]

Thanks Peter ,

The request has been shelved for now , apologise for the later response ,

Hope all is well,

Russ.

 

[Peter_SSs]

The request has been shelved for now

Cheers. No problem.