Hi I am sort of a newbie when it comes to Excel formulas. Easily confused with which formula to use when....
So Im really hoping to get some help here Thank you so much in advance.
Here is the excel problem:
I want to compare the names columns if there are matches. Afterwards, compare if the corresponding ages are same. If both are satisfied, then it returns "Y".
Otherwise, if there are no name matches, or if names match but ages don't, then it returns "N". How do I do this? I have attached screenshot. (Cant seem to attach the file itself. Thank you so much!
excel problem.png
Bookmarks