Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Microsoft Template; formula question

    A MS Excel template for warehouse management has the following line of code:

    =IFERROR(VLOOKUP([@[BIN '#]],BinLookupTable,3,FALSE),"")

    One of the columns in the table is: BIN # (no single quote mark).

    Why does this formula have a quote mark in it? Is it because the # symbol might be considered a wild card?
    Or is this because the # symbol is used in structured references and the single quote avoids that conflict?
    Is this defined somewhere?
    Last edited by kweaver; 2013-03-18 at 00:38.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Check out the use of structured table references at http://office.microsoft.com/en-us/ex...010155686.aspx

    Steve[

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    AH HA...there's the paragraph.

    Special characters in column headers that require the use of the escape character

    The following characters have special meaning and require the use of a single quotation mark (') as an escape character: Left bracket ([), right bracket (]), pound sign(#), and single quotation mark (').

Posting Permissions

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