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***
Bookmarks