Forum Discussion
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)
Sheet 2: A data table
I've attached a copy of part of the workbook for you to take a look at.
When evaluating the formula it seems to be tripping up on the date value but Excel tells me that the date value in the data table and the date on the front page are equal. This may be a simple oversight but I cannot see why it's falling over.
Any help would be very much appreciated.
Many thanks,
Tanisha
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.
2 Replies
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 :)
