look up from list of days of the week and return day of theweek value

**CANN15** · 11-11-2019, 05:08 AM

Help needed in a formula to return day of the week value based on selecting day of the week from list.
E.g. If Sunday is selected from list in cell F7 then cell H1 returns 1, if Monday is selected returns 2, if Tuesday is selected returns 3 etc...

Attached spreadsheet hopefully explains fully assistance needed.

**AliGW** · 11-11-2019, 05:13 AM

Just a bog standard VLOOKUP will do:

=VLOOKUP(F7,$C$7:$D$13,2,0)

look up from list of days of the week and return day of theweek value

LinkBack

Thread Tools

Rate This Thread

Display

look up from list of days of the week and return day of theweek value

Re: look up from list of days of the week and return day of theweek value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Calculating Years, Months, Week, Days, Hours, Minutes for Work Days between two dates

[SOLVED] How do return days,week no,month and year in between two dates

Formula to Allocate Cost every week according to the number of days in a week

[SOLVED] Find week days within the date range and return number

Week numbers and days list

[SOLVED] Loop through date data and return with days per each week of the data

Generating List of Week Working days and Identifying Holidays

Bookmarks

Bookmarks

Posting Permissions