Cell referencing issue

[LexCie]

Hi everyone, I’m new to excel. Literally just started a month ago.
So I have a spreadsheet that has a column named “Rank”. This column essentially just checks values from a column named “Revenue” and if it’s over some certain amounts, it returns “Good” or “Average” or “Poor” as the case may be. I achieved this using Nested IF function.

It was all good and fine until I woke up this morning turned on my laptop and noticed that when I click on the a cell example, L2, type in my IF function and then try to reference K2, it doesn’t write K2(from the Revenue column) as it normally would, instead it writes [@[Revenue]].

So for example instead of the formula displaying as =IF(K2<2000000,”Poor Performance”), it displays =IF([@[Revenue]<2000000,”Poor Performance”).

Although this actually returned all the correct answers I wanted it to, I think it’s messing up my table and affect mu pivot tables coz I have a pivot table that should display “Revenue by Rank” but it only 2 out of the for ranks in the Data table.

Pls how do I fix this.
Thank you

PS: I tried to attach an image of the problem, it kept tell me the image is too large. I even compressed it to 1.78mb, still didn’t work.

 

[RoryA]

Welcome to the forum.

That referencing style means that your data is in a Table, not just a normal range. That is actually better for a pivot table because it should automatically include any new data when you refresh the pivot if you set it up with the Table name as the data source, rather than a regular range, which you would have to update each time. If you select a cell in your pivot table and then click the Change Data source button on the Pivot Table Analyze tab, does it show a table name as the source data or a sheet name and cell addresses?