Nov 06 2023 12:35 PM
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 |
Yes | Yes | Yes |
Yes | No | NOT MATCHING |
Yes | Yes | Yes |
No | No | No |
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!
Nov 06 2023 01:02 PM
SolutionNov 06 2023 01:05 PM