Index Match formula with Named references

[spydey]

I am using an Index Match formula with named ranges in it.
I have done this many a times before but for some reason, this particular formula setup is not working the way I am expecting.
My named ranges are Dynamic named ranges, using Index Count.

I have a simple range setup as follows:

8 rows & 10 columns, starting at cell A1.

Items	Group1	Group2	Group3	Group4	Group5	Group6	Group7	Group8	Total
Candy
Shoes
Sweaters
Socks
Bags
Glasses
Total

My named ranges are as follows:

Item.Data = $B$2:INDEX($B:$J,COUNTA($A:$A))
Items = $A$2:INDEX($A:$A,COUNTA($A:$A))
Item.Headers = $B$1:$J$1

My formula is:

=INDEX(Item.Data,MATCH("Glasses",Items,0),MATCH("Group5",Item.Headers,0))

I am getting a #REF! error.

I have tried parsing out the individual components and get the correct answers, but when I compile the whole formula, I get the error message.

Any thoughts on what is causing the issue?

-Spydey

 

[Fluff]

Try
Item.Data = $B$2:INDEX($J:$J,COUNTA($A:$A))

 

[spydey]

BINGO!!!

Thanks Fluff!

I don't know how I missed that. I have been pouring over this formula for like the last 2 hours and missed something so simple ... lol

I appreciate you assistance. Thank you!

-Spydey

 

[Fluff]

You're welcome & thanks for the feedback.