Nth Value Index and Match

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