IF THEN formatting for adjacent cells
Hi Community,
I'm trying to format Numbers cells based on adjacent cells, with no luck.
For instance, in the below, IF A1=GH, THEN B1=150.
Is this possible?
thanks in advance :)
Hi LLB173,
Perhaps a lookup table will work for you.
The function XLOOKUP is your friend.
XLOOKUP(search-value, search-range, return-range, if-not-found, match-type, search-type)
More here:
Formula in Table 1 B2 is XLOOKUP(A2,Lookup::A,Lookup::B,A2&" Not Found",0)
Fill down.
Regards,
Ian.