INDEX MATCH Multiple Criteria across two sheets will not work

Hi All,
I'm becoming beyond frustrated. I have a small input section on 1 page where the user is able to select two criteria (the second list being limited by a selection made in the first). Once those selections are made, there are two other cells that should automatically return a value from a table in a different page. I have tried every possible method I could google, without luck. (Everything indicates an array formula however, still not working)
I'm beginning to think, at this point, it may be something to do with the initial values that are selected(?). As these are mapped directly from the table however, there may be some rounding taking place that could become the cause for a value to not pass the exact match criteria. They are calculated values.

Please see attachment to see if there is any sense to be made...

Anything you could provide would be extremely appreciated.

Thanks and Regards!,

DHT Tech

***Cross posted: https://www.mrexcel.com/forum/excel-...post4994396***

Hi,

use this formula on cell G26

Formula:

Please Login or Register  to view this content.

However with this formula, in sheet casing, you need to unmerge column C and repeat the OD (mm) label e.g cell value C30 = 120.65, C31 = 120.65, C32 = 120.65, C33 = 120.65 and cell C34 = 120.65 .

Cheers
Lex

I don't think this is a beautiful formula, but it will work.

Formula:

Please Login or Register  to view this content.

Hi All! Thanks for the awesome feedback! This works exactly as intended...
I'm going to take a moment to see if I can learn something; just to clarify, any of the formulas (array, or otherwise) refused to work due to the vertical merging of cells in my 'Casing!' tab? - Once you say it, and I type it, it immediately becomes painfully clear.

Thanks once again for the help all. I ended up using yujins solution as it didn't require me to change the back end at all.

Kind regards,

DHT Tech