Forum Discussion
Apparently, I broke xlookup() in excel
I created a large spreadsheet to help our local electrical coop set new rates. The spreadsheet is CV x 4200 cells, filled with multiple columns filled with equations. The original spreadsheet had ...
Most probably that's not due to resources as memory. That could be text instead of number, non printable character in the value, whatever. To be sure, enter in any empty cell (cell1) "123" and compare with the cell which returns result looks like "123" (cell2), entering in any other empty cell
= cell1 = cell2
if it returns TRUE or FALSE
Better if you share the sample, just few cells is enough. Copy/Paste as value (not re-write) any formula result and formula which xlookups it.