multiple(4) index match conditions

[Maulover]

excel.JPG

I attached a screen shot of my table.

I need a 4 condition index match. I have tried this in so many forms and ways, yet cannot get it to work.

I need to look up l-anch per the chosen diameter, h and also client in U15.

Three conditions (diameter, h, and l-anch row) work fine but i cannot get ti to differentiate between the tables based on the client.

This is my latest attempt of the formula.

=IF((U12="Hilti Kwik Bolt TZ Carbon Steel - ESR 1917"),(INDEX(D5:J14,MATCH(T15,B5:B14,0),MATCH("TRUE",IF(IF(D4:J4=U13,"TRUE","")="TRUE",IF(D5:J5=U14,"TRUE",""),""),0)),(INDEX(L5:R14,MATCH(T15,B5:B14,0),MATCH("TRUE",IF(IF(L4:R4=U13,"TRUE","")="TRUE",IF(L5:R5=U14,"TRUE",""),""),0)))))

Any help is greatly appreciated!!!

[Richard Buttrey]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.