Forum Discussion

justinbellpsy's avatar
justinbellpsy
Copper Contributor
Nov 06, 2023
Solved

Return the matching value if two cells match

I am looking to create a function that checks if two cells match, then return their matching value if true. A hypothetical depiction of this function is below:

 

Does Link Work? (Reviewer 1)Does Link Work? (Reviewer 2)Hypothetical Result
YesYesYes
YesNoNOT MATCHING
YesYesYes
NoNoNo

 

I can figure out whether they match, but can't seem to get to that extra step of grabbing the value shared between cells. 

 

Previous tutorials cover entering data from a third cell, but not the values from the two cells that match. Thank you so much for any solutions or leads! 

Resources