Using IF Formula on Numbers.
If i drop box select text in numbers could it automatically fill other cells in the row. for example if C1 says Apple could i use a formula to automatically add text to D1?
So in this sheet when C1 contains “Apple” could i use a formula to automatically add “Entertainment” to cell D1?
iPad Pro, iPadOS 17
