User Profile
justwork
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Disable Spill in vlookup
Is there a way to disable or turn off spill? Spill was introduced to my version of O365 Excel today and vlookup is failing to operate as it has prior to the update. In the image Sheet1 below I have a very simple vlookup in cell C5 and I only want a result in C5 which should be a value of "Cell C5" (see image Sheet2 to validate) but as you can see due to spill the field I want populated is on row 8 instead of row 5. This results in incorrect data. Moving the formula to row 2 is not a solve as this overly simplified example is to show the issue experienced. My actual data sets are much larger and span many columns across multiple sheets resulting in hundreds of thousands of errors. Any help is appreciated. Sheet1 Sheet2 - This image is of sheet2 so you can see what the text is.
