Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: What is XLookup?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Please assist me on this matter, since I am unable to find notes on this subject.
    Does it even exist???

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You might be meaning VLookup or HLookup. There are some darned fine examples of these functions on this board, try the "search" facility to find them.

    HTH

  3. #3
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Never hear of Xlookup and excel in the same sentence, sure you don't want vlookup or hlookup? Maybe xlookup is just a variable name used in a macro.

    I also seem to recall a DataLink Function called Xlookup


    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I might as well enter the fray...

    What if "X" is someone's shorthand for "V" or "H"? ...Meaning use a VLOOKUP or HLOOKUP... whichever is appropriate.

    [ This Message was edited by: Mark W. on 2002-04-17 13:10 ]

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    or maybe some crafty named formula / named range ?

  6. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    XLOOKUP is also a function used in Q&A ... I would surmise the name is intended to imly an external Lookup function!

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    XLookup is used in macro's (Sure you did not misunderstand the related topic because Vlookup & HLookup does exist which is a search facility)

  8. #8
    New Member
    Join Date
    Jul 2011
    Location
    London, UK
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: What is XLookup?

    Would I be able to revive this topic please? Saw this function today written "+xlookup" (in an Excel 2003 file - unfortunately one I couldn't get my hands on) and can't find anything more than 9 years on from this original thread.

    Any help greatly appreciated!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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