Forum Discussion
Excel formula help
Hi, new and need help with a formula..... If in cell A1 I create a drop down menu such as Monday to Friday. Then i need a formula in cell B1 that will display whatever the data is in cell C1 if Monda...
Hi,
Please try this formula:
=IF(A1="Monday",C1,IF(A1="Tuesday",C2,IF(A1="Wednesday",C3,IF(A1="Thursday",C4,IF(A1="Friday",C5,"")))))
Or one of these formulas if you have Excel 2019 or Office 365:
=IFS(A1="Monday",C1,A1="Tuesday",C2,A1="Wednesday",C3,A1="Thursday",C4,A1="Friday",C5,TRUE,"")
=SWITCH(A1,"Monday",C1,"Tuesday",C2,"Wednesday",C3,"Thursday",C4,"Friday",C5)
Hope that helps