+ Reply to Thread
Results 1 to 2 of 2

Not sure why I'm getting "[@[Header]]" when trying to reference a table for a formula

  1. #1
    Registered User
    Join Date
    12-21-2016
    Location
    Chicago, Illinois
    MS-Off Ver
    2013
    Posts
    2

    Not sure why I'm getting "[@[Header]]" when trying to reference a table for a formula

    Hello,

    When I was trying to use VLOOKUP in excel, I needed to reference cells within a table for the lookup value; however, when I click on those cells, instead of getting "A2" or something similar, I got "[@[Header]]", where "Header" is an arbitrary name for the header of the respective columns that I attempted to reference cells from.

    ex: When clicking A2 as a reference for the lookup value, instead of "=VLOOKUP(A2, ..." it would look like this: "=VLOOKUP([@[Header]], ..."

    This isn't a huge issue, I already bypassed the problem. I was just curious why that is and I wanted to learn a little. Thanks for any info! :)

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,443

    Re: Not sure why I'm getting "[@[Header]]" when trying to reference a table for a formula

    Hi,

    It sounds like you have a table defined. Office support describes it better than I ever could - take a look here
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] "Read" the column header "Element" and perform calculation
    By dwsf in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-15-2015, 01:41 AM
  2. = EMBED("Forms.ComboBox.1","") error "Reference not valid."
    By CatharinaCatharina in forum Excel General
    Replies: 2
    Last Post: 12-11-2014, 09:58 AM
  3. [SOLVED] Replace all BLANK cells in column with header title "Balance" to "0"
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2014, 09:25 AM
  4. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  5. [SOLVED] Delete the Rows If it is Blank cell below Table header "Status"
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2012, 05:55 AM
  6. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  7. How to change "total" header in a pivot table
    By katie_10042 in forum Excel General
    Replies: 2
    Last Post: 05-27-2010, 06:02 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1