XLOOKUP Function exist-- as a followup to a post dated 2012

[GGY_AXIS]

This post is meant to be a reply to the old 2012 post that I just read. The site does not allow me to reply to the old post-Link below-

https://www.mrexcel.com/forum/excel-questions/5404-what-xlookup.html

I just want to revive this question because I am working on a project where XLookup could save me a lot of time but I NO-LONGER have access to the source where I originally found the XLOOKUP in use:
Yes, there is function name “XLookup” and it is used extensively in an Actuarial software name “GGY AXIS”---Insurance software.
It is similar to a VLookup in the sense you are looking a record base on criteria in one field
BUT
The XLookup allow you to look up a table base on criteria in multiple fields.
I am not talking about concatenation of multiple fields for VLookup purpose.
In this type of environment concatenation is not an option so the XLookup turn out to be a life saver.

An example is that you might want to look up criteria such as a table and have to find matching fields such as "Basis", "Rate", "Kind", " Merger codes" or more and choose a result in another column based on these criteria.

Anyone feel free to research and expand on the above note.

 

[Michael M]

As Xlookup doesn't exist in native Excel formulas, I'm guessing it is either an addin or a Custom UDF.
Here are a couple fo links that may be of assistance in this matter

https://www.mrexcel.com/forum/excel-questions/88986-udf-xlookup.html

Format Cells | Excel & VBA Development – UDF: XLOOKUP – Using VLOOKUP for left AND right searches

 

[FDibbins]

In this type of environment concatenation is not an option

Not sure why you would say that, can you explain further?

An example is that you might want to look up criteria such as a table and have to find matching fields such as "Basis", "Rate", "Kind", " Merger codes" or more and choose a result in another column based on these criteria.

I don't see how a criteria "table" could be in any way linked to those? Again, care to explain further?

 

[GGY_AXIS]

FDibbins this part was a typo: as <strike>a table and have to find matching fields such as</strike>

The links given by Michael M is not the same as the original question.
Now that we are on the topic I found another question online related to XLOOKUP. I am assuming it is ok to add the link from outside of this group

https://www.alphasoftware.com/alphaforum/showthread.php?23221-XLOOKUP

 

[FDibbins]

Thanks for clearing that up, I am a typo-king lol

As Michael said, xlookup is not a native excel function, and you mentioned it was from another software package, so either it was not in excel that you used it, or someone wrote some code to emulate it.

If you explain exactly what you are trying to achieve, maybe we can come up with something for you?

 

[Michael M]

Alpha Software is a company that creates custom apps and functions.....mainly for databases, I believe

Yes, there is function name “XLookup”

Not in Excel there isn't....as mentioned earlier it will be a UDF or addin.....

 

[MARK858]

From what I can see xlookup is a function within Excel Power Expander by Vonixx.

Excel Power Expander 4 - Worksheet Function Reference

 

[GGY_AXIS]

Thanks to all!!!
.....nd you mentioned it was from another software package, so either it was not in excel that you used it, or someone wrote some code to emulate it.....


FDibbins is right to the point. The software in question AXIS is a close system. There is no way for users to know the behind the scene process. More likely "There are some code in action" that make it work within the software.

Best!