Hi,
I noticed this a few version back, last week, from Excel 2016, that when I got a table and do a HLookup, using a popup list, then the first Item is not found in the list and copied into the cells.
If I make the table reference smaller, meaning leave the row title (first column) out, then it works. But I can't do that because somewhere else I need the first column to search for the row title.
Any suggestions?
I got now at least 8 or 9 WB not working correctly.
Bookmarks