We help IT Professionals succeed at work.
Get Started

Understanding Tables and their Impacts on Formulas

-Polak
-Polak asked
on
59 Views
Last Modified: 2015-03-11
Relatively easy one here, I've never used tables heavily, because up until Excel 2013 there wasn't much reason (in my humble opinion) now because of Slicers, Data Models, Power Pivot, etc... I can see an advantage. Here's my question....

I've become very used to cell references in formulas, take for example the below array (CTRL+SHIFT+ENTER):
{=AVERAGE(IF((AircraftData!$E$2:$E$301=AnalysisEngine!$B18)*ISNUMBER(MATCH(AircraftData!$D$2:$D$301,ConstrainedReqs!$B:$B,0)),AircraftData!$F$2:$F$301))}

Now "AnalysisEngine!$B18" is in my newly created table. But I notice that it hasn't changed the name of that cell reference to the name of the header Column "[@Asset]". What I'm trying to figure out for my self is if I Love/Hate that it doesn't do that automatically, and if I should change it.

So basically, should I be using them instead of cell refs, and what do I need to be aware of if I do? For example, pressing F4 no longer makes something absolute in position.... what if I wanted that.
Comment
Watch Question
CERTIFIED EXPERT
Top Expert 2015
Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE