Xlookup bugs -Auto poputate& Fetch Entire Record

[Rakshith]

used formula =XLOOKUP(F2,A2:A15,B2:D15)

Taken from: https://trumpexcel.com/xlookup-function/#Example-2-Lookup-and-Fetch-an-Entire-Record

Example 2: Lookup and Fetch an Entire Record

The result becomes #VALUE! in MS excel 2013, (not tried in Excel 2019)

The same formula working well in online excle-ondrive.

please check it out.

[Rakshith]

Please make correction as Auto Populate in Subject

[Govert van Drimmelen]

This issue is related to the older Excel version not supporting the Dynamic Arrays feature.

So even though you get an implementation of XLookup with the XFunctions add-in, it doesn’t give you the dynamic array expansion of the result that you see in new Excel.

If you select all three cells and enter the formula as an array formula with Ctrl+Shift+Enter, I think it will work (I have not tried it myself, though).

 

Does that make sense?

 

-Govert

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/ebe26f70-0bb2-450d-8b69-01b62f7a7894n%40googlegroups.com.