[#Headers] question ?

[PSmith999]

I am trying to modify an existing spreadsheet that was created by an Excel power user. After I added more rows to the data table, there is one reference look up that is return an error.

Specifically the line is

=INDEX(CountryProduct,[@[Master ID]],MATCH(N$4,CountryProduct[#Headers],0))


I know what the CountryProduct and Master ID references are but I am struggling to reference the [#Headers] term. I can't tell if it's a predefine range within the document or a excel function to read across a "header' range on a table.

Any thoughts on how I can identify this?

Thanks,

Paul

 

[starl]

#Headers is a pre-defined range (so to speak) for the headers of the table. It's a quick way of automatically referencing the header row of the table.

 

[starl]

I don't see anything wrong with the formula you're using, but it's possible the row reference being returned is outside the table. For example if the returned row is 500 but you only have 499 rows in the table BODY - you'll get an error.

 

[PSmith999]

Thank you -

I can run this formula on another machine and it works fine. There must be something in the set up, as you suggested.

Paul

 

[starl]

Have you traced the formula to figure out which part has an error? What is the error?
Honestly, there are so many possibilities of what the problem could be, but without seeing anything..
Are you sure it's calculating? Is Auto calculation on?