What is XLookup?

lady · Apr 17th, 2002, 01:52 PM

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

Mark O'Brien · Apr 17th, 2002, 01:54 PM

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 · Apr 17th, 2002, 02:05 PM

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. · Apr 17th, 2002, 02:08 PM

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 · Apr 17th, 2002, 03:52 PM

or maybe some crafty named formula / named range ?

Yogi Anand · Apr 17th, 2002, 04:36 PM

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

gareth · Apr 17th, 2002, 11:41 PM

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 · Jul 13th, 2011, 12:31 PM

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!

Apr 17th, 2002, 01:54 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 17th, 2002, 02:05 PM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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 __________________ Kind regards, Al Chara

Jul 13th, 2011, 12:31 PM	#8
PCasso New Member Join Date: Jul 2011 Location: London, UK Posts: 1	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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 01:52 PM	#1
lady New Member Join Date: Apr 2002 Posts: 3	Please assist me on this matter, since I am unable to find notes on this subject. Does it even exist???

Apr 17th, 2002, 02:08 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Apr 17th, 2002, 03:52 PM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	or maybe some crafty named formula / named range ?

Apr 17th, 2002, 04:36 PM	#6
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	XLOOKUP is also a function used in Q&A ... I would surmise the name is intended to imly an external Lookup function!

Apr 17th, 2002, 11:41 PM	#7
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	XLookup is used in macro's (Sure you did not misunderstand the related topic because Vlookup & HLookup does exist which is a search facility)