Oct 16 2019 07:41 AM
Oct 16 2019 08:08 AM
See if the attached workbook achieves what you are after.
Oct 16 2019 08:14 AM
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
Oct 17 2019 12:17 AM
Oct 17 2019 02:29 AM
You may also use LOOKUP like this:
=LOOKUP(2,1/(
{"Monday";"Tuesday";"Wednesday";"Thursday";"Friday"}=A1),
C$1:C$5)