Thread: [Solved] Excel 2013 ... @...???
View Single Post
 
Old 10-02-2014, 02:16 PM
Bromance Bromance is offline Windows 7 64bit Office 2013
Novice
 
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