How to display User Defined Function result in form of reference instead of value

%3CLINGO-SUB%20id%3D%22lingo-sub-1583640%22%20slang%3D%22en-US%22%3EHow%20to%20display%20User%20Defined%20Function%20result%20in%20form%20of%20reference%20instead%20of%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1583640%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20make%20my%20own%20XLOOKUP%20function%20in%20VBA%20and%20have%20succeeded%20to%20some%20extent%20as%20such%20I%20can%20find%20and%20display%20values%20in%202-d%20arrays%20too%20but%20when%20I%20try%20to%20use%20nested%20function%20then%20it%20displays%20error.%20By%20doing%20some%20google%20search%20I%20concluded%20that%20XLOOKUP%20gives%20output%20as%20references%20instead%20of%20values%2C%20while%20my%20UDF%20displays%20actual%20values.%20So%2C%20has%20anyone%20tried%20anything%20similar%3F%20Any%20suggestions%20are%20welcomed.%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1583640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1583941%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20display%20User%20Defined%20Function%20result%20in%20form%20of%20reference%20instead%20of%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1583941%22%20slang%3D%22de-DE%22%3EIt%20would%20be%20an%20advantage%20for%20everyone%20if%20you%20upload%20a%20file%20(without%20sensitive%20data)%20and%20make%20it%20available.%20With%20that%20one%20could%20help%20them%20more%20specifically%20and%20more%20quickly.%20At%20the%20same%20time%2C%20you%20save%20us%20the%20time%20to%20guess.%20%3CBR%20%2F%3E%20I'm%20not%20that%20good%20at%20guessing%20and%20spells.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I am trying to make my own XLOOKUP function in VBA and have succeeded to some extent as such I can find and display values in 2-d arrays too but when I try to use nested function then it displays error. By doing some google search I concluded that XLOOKUP gives output as references instead of values, while my UDF displays actual values. So, has anyone tried anything similar? Any suggestions are welcomed. Thanks in advance!

1 Reply
It would be an advantage for everyone if you upload a file (without sensitive data) and make it available. with that one could help them more specifically and more quickly. At the same time, you save us the time to guess.
I'm not that good at guessing and spells.

Nikolino
I know I don't know anything (Socrates)