PASTEL XPRESS19 INTELLIGENCE REPORTING ERROR

**BeInHealth** · 11-Apr-23, 03:07 PM

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.

Click image for larger version.

Name: Intellig Report Error.jpg
Views: 107
Size: 51.5 KB
ID: 8737

**Neville Bailey** · 12-Apr-23, 07:28 AM

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

**BeInHealth** · 12-Apr-23, 08:33 AM

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** · 12-Apr-23, 08:48 AM

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.