Help with nested Index Match formula

[LilSisKin]

Please help. I have been trying to get this formula to work for 2 hours now and I can't seem to figure out what is wrong with it.

=INDEX(Lookup!$D$2:$J$529, MATCH($O4&$Q$3,Lookup!$C$2:$C$529,0), MATCH(P$3, Lookup!$D$1:$J$529, 0))

I have attached a copy of my spreadsheet showing the raw data table and lookup table for reference.Archery Elk Stats.xlsx

[Tony Valko]

I didn't look at your file.

In the last MATCH function the table_array range needs to be a single row.

MATCH(P$3, Lookup!$D$1:$J$529, 0)

Maybe it needs to be:

MATCH(P$3, Lookup!$D$1:$J$1, 0))

[LilSisKin]

It is still resulting in a #N/A. :-(

[Tony Valko]

I can't download the file. I have a file size limit of 50kb.

You can narrow down where the error is being generated by entering the individual MATCH functions by themselves in separate cells:

=MATCH($O4&$Q$3,Lookup!$C$2:$C$529,0)

=MATCH(P$3,Lookup!$D$1:$J$1,0)

[LilSisKin]

Thanks. That worked perfectly.

[Tony Valko]

Good deal. Thanks for the feedback!