Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2014, 02:16 PM
Bromance Bromance is offline Excel 2013 ... @...??? Windows 7 64bit Excel 2013 ... @...??? Office 2013
Novice
Excel 2013 ... @...???
 
Join Date: Oct 2014
Posts: 1
Bromance is on a distinguished road
Default Excel 2013 ... @...???

So, I am taking an advanced Office course in college. We are currently working in Excel.


I missed a submission on the online homework site, yet my formula seemed correct and yielded the appropriate result.
I asked my instructor what was wrong with my formula and he told me to use the "@" symbol and learn what it does...
So far, I do not know what it does and Google is yielding literally no results (not to mention our course book doesn't mention it).

Background info on homework:
I was working in data tables and structured formulas. The formula I was using was VLOOKUP.
For some reason, when I referenced the table as =VLOOKUP(Table[Column_Name....]) it yielded the right result. But I had to put =VLOOKUP(Table[@[Column_Name...]]).

So, what is the difference between using the "@" symbol and not using it?
Under what circumstances would you use one or the other?

Thanks for taking the time!
Reply With Quote
  #2  
Old 10-02-2014, 04:30 PM
macropod's Avatar
macropod macropod is offline Excel 2013 ... @...??? Windows 7 64bit Excel 2013 ... @...??? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There was nothing wrong with your formula. In 30 years of using Excel, I've never encountered the @ as something required in any Excel formula, unless it was part of something being tested. Mind you, I generally prefer to an INDEX/MATCH combination instead of VLOOKUP because INDEX/MATCH works with unsorted data.

AFAIK, the @ is a compatibility option left over from the days of Lotus 123, which did require it. Excel allows the @ but does not require it and it adds nothing to what you already had, except clutter. If the Lotus compatibility character is what it is and this is supposed to have been an Office course, your instructor was wrong.

If your instructor is going to tell you you're wrong, challenge him to produce an example where it does make a difference, and a reference to it. Simply telling you to "learn what it does" without providing any relevant material is unreasonable.

Even Microsoft's documentation makes no mention of it. See:
http://office.microsoft.com/en-au/ex...010343011.aspx
https://support.office.com/en-US/Art...rs=en-US&ad=US
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

FWIW, IBM - the owner of Lotus 123 - doesn't even sell or support it any more. The last release of Lotus 123 was version 5 ... in 1994!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-03-2014, 02:06 PM
gebobs gebobs is offline Excel 2013 ... @...??? Windows 7 64bit Excel 2013 ... @...??? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

When making formulas using table automation, Excel puts the @ symbols in automatically. Sometimes, they aren't necessary and if you take them out, the formula returns the same result. Other times, not so much.

It seems to me is what it's saying is: take the cell in this row (i.e. the same one as the formula is in) @ this column and do some operation with another cell @ this column.

e.g. =([@Widgets]-[@Flanges])/[@Flayrods]

If Widgets are in A, Flanges in B, Flayrods in C, that is how the equation would appear if you enter the formula in D2 and clicked the cells in A2, B2, and C2 to generate it.

I can take out the @ symbols and the equation works fine.

=([Widgets]-[Flanges])/[Flayrods]

However, if I do a sum of the same columns, the equation appears as:

=SUM(Parts[@[Widgets]:[Flayrods]])

Take out the @ symbol, and the formula returns a #REF! error.
Reply With Quote
Reply

Tags
vlookup

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2013 ... @...??? Excel 2013 crashing aki Excel 2 05-26-2014 01:38 AM
Excel 2013 ... @...??? Excel 2013 - Sparklines Grayed Out OneNoteFanatic808 Excel 1 01-23-2014 09:39 PM
Excel 2013 ... @...??? Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file samsnov Excel 5 09-29-2013 04:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft