I need help on how to get the result in column B from the table range in column D and E. The PRIORITY is to search for a word/string first from column D from the given value in column A, if the value is not present in the column D search in column E but will return the value in Column D.
Looking at the example below, all the values from cell A2:A6 can be found in column D except for cell A7 which can only be found in Column E.
Looking at the example below, all the values from cell A2:A6 can be found in column D except for cell A7 which can only be found in Column E.