INDEX MATCH AND formula assistance

Michelle Basson

I currently have a formula to determine the day of the week when a date is selected, which works perfectly.

=IF(WEEKDAY([Overtime Date]@row) = 1; "Sunday"; IF(WEEKDAY([Overtime Date]@row) = 2; "Monday"; IF(WEEKDAY([Overtime Date]@row) = 3; "Tuesday"; IF(WEEKDAY([Overtime Date]@row) = 4; "Wednesday"; IF(WEEKDAY([Overtime Date]@row) = 5; "Thursday"; IF(WEEKDAY([Overtime Date]@row) = 6; "Friday"; IF(WEEKDAY([Overtime Date]@row) = 7; "Saturday")))))))

I have added a checkbox which should be selected if the day is a public holiday.

The index match references the table below to determine the amount it should be multiplied by.

I need to change the formula to include that if the Public Holiday box is selected, the amount to multiply by should be 2,0.

I do not know if the INDEX MATCH is the correct formula for this, or whether I should rather be using a VLOOKUP IF formula.

Any assistance will be appreciated.

M

Michelle Basson

Hi @Andrée Starå

I am very well, thanks. Hope you are doing great.

This is so ovbious 🤦🏼‍♀️

Must be the late nights breaking my brain. Thanks for the spot on response. Really appreciate.

Have a great day.

M

Andrée Starå

Hi @Michelle Basson

I hope you're well and safe!

If I understand you correctly, you should only need to add an IF function to check if the Public Holiday checkbox is checked, then it should show 2, or if it isn't, run the INDEX/MATCH formula.

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Michelle Basson

Hi @Andrée Starå

I am very well, thanks. Hope you are doing great.

This is so ovbious 🤦🏼‍♀️

Must be the late nights breaking my brain. Thanks for the spot on response. Really appreciate.

Have a great day.

M

Andrée Starå

@Michelle Basson

Excellent!

Glad to hear you're well, and I am too!

Easy to miss!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!