I am trying to find a formula to put into Sheet 1 column B. I need to match up the numbers from Sheet 1 column A to Sheet 2 column C and ONLY display the text from from Sheet 2 column D if it is "XXX."
Example:
Sheet 1:
A B1 1111 (=Formula only show "XXX") 2 2222 (=Formula only show "XXX") 3 3333 (=Formula only show "XXX") 4 4444 (=Formula only show "XXX")
Sheet 2:
C D1 1111 XXX 2 2222 YYY 3 3333 ZZZ 4 4444 XXX
Bookmarks