Forum Discussion
Formula Spill
I am needing to complete a vlookup that does not spill into other fields. How can I stop it?
5 Replies
To stop this, make sure that the formula you are using returns a single value. Are you using more than one Lookup_Value (the first argument in the formula) in VLookup Formula?
There is only one VLOOKUP formula available to use.
Maybe you are using one formula but obviously it is not a correct formula - hence the spilling.
Function is only one, but it's infinite number of ways to use it. Plus similar functions as XLOOKUP, LOOKUP, INDEX/MATCH,..
Use a correct VLOOKUP() formula.
