Forum Discussion
stillwatergirl
Jun 06, 2025Copper Contributor
Xlookup Displays Previous Match Results When Blank
Hi, I created an Xlookup formula that looks for a match in cell B1 of my spreadsheet (see image below), returning data from other sheets in my workbook. The formula functions perfectly when there is ...
NnyiimockBitanyanmi
Jun 08, 2025Brass Contributor
I suggest you change where the data should display thus, B1, C and D. This is not formated as a table, so it should work.