Aug 12 2020 12:45 AM
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!
Aug 12 2020 02:59 AM