multiple(4) index match conditions

[Maulover]

Attachment 496857

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]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Pictures are rarely much use.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[Pete_UK]

As Richard says, a picture is not much use, although I can actually read the details from this one compared to your earlier (duplicate) thread. It strikes me that the value of h is dependent on the diameter (and client/table), so it can be derived in a similar way as for the l-anch value, so it's only really a 2-variable problem where you want a formula in cells U14 and U15 derived from the user input in U12 and U13.

It would help if you attached a sample Excel workbook, so we can try out different approaches.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

[Maulover]

i uploaded the file.
Thanks again

[José Augusto]

Hi

Use this formula in U15

Please Login or Register  to view this content.

use in E2:J2 "CL1" and L2:R2 "CL2"

see the file

[Maulover]

perfect. that did exactly what i need it to do. Ty

[José Augusto]

Thanks for the feedback.