Forum Discussion
Excel is reading data differently with spaces vs without spaces
I have sheet 1 that is reading data from sheet 2 (the data includes spaces), but for some reason when I delete the spaces on Sheet 1 it pulls different data from sheet 2. Here is the formula I'm usi...
Try adding ,0 at the end of your lookup. This is the same as FALSE and tells Excel you’re looking for an exact match for A2:
=IF($A3>" ",VLOOKUP($A3,Sheet1!$A$2:$T$18748,9,0)," ")
=IF($A3>" ",VLOOKUP($A3,Sheet1!$A$2:$T$18748,9,0)," ")