Hello everyone, beginner excel user here so please bear with me as I try my best to explain my problem.

I have a worksheet which contains two spreadsheets. I am trying to pull a value from worksheet #2 and put it into worksheet #1 based on two matching criteria (client name & date). I have used the index and match function but it is not returning the values in which I need.

Here is the function I am currently using : =INDEX(Flow!$C$5:$AH$31,MATCH(Chart!$A$2,Flow!$C$5:$C$31,0),MATCH(Chart!Y8,Flow!$4:$4,0))

I've been at this for hours with no luck

Anyways, any help would be appreciated. I've also attached a copy of the excel file.help.xlsm