Nth Value Index and Match

[TuboDieselOne]

Good Evening.
I need your help on this one as the nth value index and match. I have attached a file and in the Table 1 tab there is a formula

IF([@[Authorised Hrs]]="TIMESHEET","TIMESHEET",IFERROR(INDEX(Days,MATCH([@[Employee Ref]],ID,0),MATCH([@DAY],Digit,0)),""))

its the bit with
INDEX(Days,MATCH([@[Employee Ref]],ID,0),MATCH([@DAY],Digit,0)) i need to add the nth lookup of

[@[Employee Ref]] in a named range ID. and as there is a column called Days in Table1 it has to lookup depending on the column in the Lookup Data that ranges from Monday to Sunday.
I have coloured the columns to highlight this.

Thanks in advance for your help.

Kindest regards

[Glenn Kennedy]

A formula that does not work on a sheet, with a limited explanation, and no expected answers doesn't provide enough to go on.


please repost in this thread with some expected answers and an explanation describing how they were derived.

[TuboDieselOne]

Sorry I thought the title was suggested enough.
I need to use index and match and if the match exists more than once give me the nth Match.

[AliGW]

You provided a sample workbook with no sample data or example results (manually calculated), so we can't see what you are aiming for.

Please update the sample worksheet and attach it again here.