https://bugs.documentfoundation.org/show_bug.cgi?id=172850
--- Comment #3 from [email protected] --- Created attachment 207792 --> https://bugs.documentfoundation.org/attachment.cgi?id=207792&action=edit xlookup solution with the prefix patch Hi, the `_xlfn.XLOOKUP` solution works. Thank you. But this seems more like a workaround rather than a working solution. I have attached the xlsx file generated from the script above if you would like to have a crack and implement a proper solution, otherwise, I'm okay with treating this ticket as completed since there's a workaround available. Thank you again for the quick response. -- You are receiving this mail because: You are the assignee for the bug.
