[Question] PASTEL XPRESS19 INTELLIGENCE REPORTING ERROR

[BeInHealth]

I have written three reports in Intelligence Reporting, It works perfectly fine until I create a new company (at year end). The report shows NA# on all the cells which should have values.

It is only at year end that I experience this and would obviously not like to rewrite the reports. This happens even if I run the Feb 23 report in the new company, yet when I run it in the previous year company I do not have any errors.

Can someone please assist.

[Neville Bailey]

Open the Lookup sheet and edit cell A1 from February 2023 to February 2024.

[BeInHealth]

Hi Neville

Thankyou for your reply and assistance. Here is the cell as is -

=HLOOKUP("CompanyName",Sheet1!CompanyName,2)

Not quite sure if I should change it to.

[Neville Bailey]

Follow the formula and see if you can spot the cell that needs to be edited that way.

You are welcome to email me a copy of the Excel report so that I can look at it in detail.

[BeInHealth]

Thanks Neville

Much appreciated.