Hi guys,
I have tried, youtubed etc however still can't manage to figure this out (noob here). When I try index and match it returns as spill/error. I am trying to use B2 and B3 as changeable variables as per below. The length of employment is the column D and as rows will always be either 3,4,5,10 and as shown below it is '5' this should go across the columns F,G,H,I to fetch the data and return value H6 (£12).
I hope this makes sense?
I have tried, youtubed etc however still can't manage to figure this out (noob here). When I try index and match it returns as spill/error. I am trying to use B2 and B3 as changeable variables as per below. The length of employment is the column D and as rows will always be either 3,4,5,10 and as shown below it is '5' this should go across the columns F,G,H,I to fetch the data and return value H6 (£12).
I hope this makes sense?