What is XLookup?

[lady]

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

 

[Mark O'Brien]

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

 

[Al Chara]

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

 

[Mark W.]

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

 

[Chris Davison]

or maybe some crafty named formula / named range ?

 

[Yogi Anand]

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

 

[gareth]

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

 

[PCasso]

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!

 

[MrExcel]

XLOOKUP is an amazing new replacement for VLOOKUP, HLOOKUP, LOOKUP, INDEX-MATCH, even INDEX-MATCH-MATCH. It was released on August 28, 2019. The curious part is how our OP heard about this back in 2002!

Details: https://www.mrexcel.com/excel-tips/the-vlookup-slayer-xlookup-debuts-excel/