What is XLookup?
VBA Telemetry pings you when your VBA projects fail
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!

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
  •  

 

 
DMCA.com