(see image above) I want to compare each cell in column B to the values in columns I and J. And if a cell in column B contains the same value as a cell in column I or J I want column D to give me the same value that I have in the cell in column K that is in the same row as the value in column I or J that matched with the cell in column B.
So as a result I want the following:
How di I make this happen ?