Hi everyone. I have attached a sample spreadsheet with the required data and the outcome I need in bold.
I need to pick out a cost from one column based on the selections made in Columns A, C and D.
I assume it would be an INDEX/MATCH formula, but that's where it ends for me.
Could someone advise what the formula would be?
If I Select the Day, the time worked and the level of the person, I would like the formula to look up the corresponding Rate in the columns of Rates on the right of the spreadsheet.
Thank you for your assistance/answers.
Bookmarks