I am needing to complete a vlookup that does not spill into other fields. How can I stop it?
Use a correct VLOOKUP() formula.
There is only one VLOOKUP formula available to use.
Function is only one, but it's infinite number of ways to use it. Plus similar functions as XLOOKUP, LOOKUP, INDEX/MATCH,..
Maybe you are using one formula but obviously it is not a correct formula - hence the spilling.
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?