Forum Discussion
Solved
INDEX MATCH MATCH #N/A Error
Hello,
I'm looking for some help with an INDEX MATCH MATCH formula across 2 sheets please.
Sheet 1: A front page (refs to other sheets have been replaced with values for the sample attached) ...
Hi Tanisha,
Second MATCH doesn't work in your formula. In general it's not necessary to use absolute references, structured one work, like
=INDEX(Table8,MATCH(CONCATENATE("BrightonTeam Name 1Staff 1",E$7),Table8[Select Team Data Ref],0),MATCH(TEXT($D$6,"dd/mm/yyyy"),Table8[#Headers],0))And see attached. If I understood your logic correctly.
Hi Tanisha,
Second MATCH doesn't work in your formula. In general it's not necessary to use absolute references, structured one work, like
=INDEX(Table8,MATCH(CONCATENATE("BrightonTeam Name 1Staff 1",E$7),Table8[Select Team Data Ref],0),MATCH(TEXT($D$6,"dd/mm/yyyy"),Table8[#Headers],0))
And see attached. If I understood your logic correctly.
- This is fantastic and solves a problem I've been trying to solve all morning!
Thank you very much for you clear and concise solution. It's very much appreciated :)
