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 to 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.
As I am not yet allowed to post attachments, I hope my description will suffice.
Anything you could provide would be extremely appreciated.
Thanks and Regards!,
DHT Tech
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 to 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.
As I am not yet allowed to post attachments, I hope my description will suffice.
Anything you could provide would be extremely appreciated.
Thanks and Regards!,
DHT Tech
