How to Do If the value in Column A matches with Column C in a different row, then show the value in Column B based on Column C, otherwise show null
Column A | Column B | Column C | OutCome Like |
null | Apple | rec-1 | null |
rec-4 | Banana | rec-2 | Carrot |
rec-6 | Pomo | rec-3 | France |
rec-5 | Carrot | rec-4 | Elaki |
rec-10 | Elaki | rec-5 | Berry |
rec-5 | France | rec-6 | Elaki |
rec-4 | Greece | rec-7 | carrot |
rec-7 | Himachal | rec-8 | Greece |
null | Orange | rec-9 | null |
null | Berry | rec-10 | null |