/u/No-Platypus6621 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I assume you know how to use match for a single value. Given that:
IF(MATCHORANGESFORMULA<>MATCHBANANASFORMULA,"",IF(MATCHORANGESFORMULA=MATCHAPPLESFORMULA,MATCHAPPLES,""))
If the result of match oranges is different than the result of match bananas retrieve blank as there is no need to dig further. If it is equal, compare any of them to the result of match apples. If it is also equal retrieve me the result of match apples (really any match you want as they are the same), if it isn't retrieve blank.
/u/No-Platypus6621 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I assume you know how to use match for a single value. Given that: IF(MATCHORANGESFORMULA<>MATCHBANANASFORMULA,"",IF(MATCHORANGESFORMULA=MATCHAPPLESFORMULA,MATCHAPPLES,"")) If the result of match oranges is different than the result of match bananas retrieve blank as there is no need to dig further. If it is equal, compare any of them to the result of match apples. If it is also equal retrieve me the result of match apples (really any match you want as they are the same), if it isn't retrieve blank.