need to create formula to return the column title of f and g if the item is not in t 5133832
Need to create formula to return the column title of F and G. If the item is not in the list, the formula should return the same name.
Example: Cell D8 should return “Team UU” because remote is under the list in column G
Cell D9 should return “Team LL” because phone is under the list in column F
Cell D10 should return “Wallet”, because it's in neither of the columns lists, therefore it should return the same name.
This should be the result after the formula:
Team LL Team UU Backpack Remote Phone Chair 4 Cup Remote Phone Wallet Chair Apple Cup Keys Backpack Sign 9 10 12 13 14 15 16