What is XLookup?

lady

New Member
Joined
Apr 14, 2002
Messages
3
Please assist me on this matter, since I am unable to find notes on this subject.
Does it even exist???
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
XLOOKUP is also a function used in Q&A ... I would surmise the name is intended to imly an external Lookup function!
 
Upvote 0
XLookup is used in macro's (Sure you did not misunderstand the related topic because Vlookup & HLookup does exist which is a search facility)
 
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,957
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top