INDEX/MATCH Function - 2 Criteria for Column & 1 Criteria for Row
florntn
Posted messages
2
Status
Member
-
florntn Posted messages 2 Status Member -
florntn Posted messages 2 Status Member -
Hello,
I have implemented the INDEX/MATCH function with a column criterion and a row criterion to search for a value in a table. It works wonderfully.
I would now like to do the same but with an additional column criterion. To find my value, I need two column criteria and one row criterion.
Thank you in advance,
The file: https://www.dropbox.com/s/d71yrt95viuuxuj/Florntn.xlsx?dl=0
Configuration: Windows / Chrome 63.0.3239.84
I have implemented the INDEX/MATCH function with a column criterion and a row criterion to search for a value in a table. It works wonderfully.
I would now like to do the same but with an additional column criterion. To find my value, I need two column criteria and one row criterion.
Thank you in advance,
The file: https://www.dropbox.com/s/d71yrt95viuuxuj/Florntn.xlsx?dl=0
Configuration: Windows / Chrome 63.0.3239.84
1 answer
-
Good evening
there's no way to access your model without signing up. Try uploading it here:
http://mon-partage.fr
but already on principle:
according to your images, it won't be possible to retrieve data from merged cells if needed (?)
otherwise, on principle, the array formula to enter by pressing enter while holding the ctrl and shift keys down:
(it should automatically display between curly braces in the formula bar)
=INDEX(field to extract;MATCH(lookup value 1&lookup value 2;field 1&field 2;0))
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
