How do I write this formula?
If column B contains column A value, return value in column C.
Example:
Column A Column B Column C
1026 BLACKHAW ST 1022 Blackhaw St Friendswood, MD. 03079-1002 ##
835 WYCLIFFE DR 1026 Blackhaw St Friendswood, MD. 03079-1002 SS
618 WOODBEND LN 1100 Blackhaw St Friendswood, MD. 03079-1003 QQ
FOREST DR 1102 Blackhaw St Friendswood, MD. 03079-1003 WW
PEBBLEBROOK DR 1106 Blackhaw St Friendswood, MD. 03079-1003 QQ
Carolcrest 847 Wycliffe Dr Friendswood, MD. 03079-3511 AA
CHADBOURNE DR 843 Wycliffe Dr Friendswood, MD. 03079-3511 QQ
Britoak 839 Wycliffe Dr Friendswood, MD. 03079-3511 AA
Bookmarks