Oct 25 2020 11:34 AM
I am needing to complete a vlookup that does not spill into other fields. How can I stop it?
Oct 25 2020 12:09 PM
Function is only one, but it's infinite number of ways to use it. Plus similar functions as XLOOKUP, LOOKUP, INDEX/MATCH,..
Oct 25 2020 01:12 PM
Maybe you are using one formula but obviously it is not a correct formula - hence the spilling.
Oct 25 2020 11:30 PM
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?