Forum Discussion
Solved
If Then Help
Hey guys, I am having problems with a simple formula (it's been that kind of day). I am looking for a formula that will change the Day# in gray, when the blue day of the week changes. Monday ...
- You could also try:
="Day "&MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)
=VLOOKUP(Y1,$AC$1:$AD$5,2,FALSE)Why not with VLOOKUP and a reference table in range $AC$1:$AD$5 for example?
=IF(Y1="Monday","Day1",IF(Y1="Tuesday","Day2",IF(Y1="Wednesday","Day3",IF(Y1="Thursday","Day4",IF(Y1="Friday","Day5")))))
- You could also try:
="Day "&MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)- beautiful
Yes, that’s a much more elegant solution.
