I am having a hard time thinking of an formula that can help me pull the data needed in this example:
In the C1 cell, I would like to make a formula that does this:
- Check if any cells in the A column contain the value that appears in B1
- If it finds a match, return the value from the A column but only if it is longer than the value that is already in B1
- If there is no such match, return the value of B1 again
So in this example, it should return "Bob Jones"
Any help would be greatly appreciated!