Menu
support@authoritypapers.com
+1(805) 568 7317

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.

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

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

"Order a similar paper and get 15% discount on your first order with us
Use the following coupon
"GET15"

Order Now