XFunctions
XFunctions copied to clipboard
Excel-DNA
XLOOKUP and XMATCH for all Excel versions
Hi I have add in ExcelDna.xfunction version 5. only very basic function is working like use it as vlookup, most the function doesn't work  for example if my lookup...
version 0.2 works perfectly as far as I can tell. except the return array doesn't seem to return an array. so lets say I have xlookup(b2,"another-document!a3:a107,another-documenta!3:e107) it should return all...
See https://exceljet.net/formula/xlookup-with-complex-multiple-criteria and https://groups.google.com/g/exceldna/c/bwXlP-OXfPM If seems that a formula like ``` =XLOOKUP(1,(LEFT(B5:B16)="x")*(C5:C16="east")*NOT(MONTH(D5:D16)=4),B5:E16) ``` is evaluated differently in Dynamic-Array aware Excel vs older Excel. In particular, the LEFT and MONTH functions...
after successful install of the add-in, excel 13 still place _xlfn. in front of xlookup formulas every time the sheets were opened.
The Xlookup Function works fine to get single values but not for multiple values. It keeps returning errors
When I use xlookup and search about last value it dose not work and show #value error
