Formula Spill

Copper Contributor

I am needing to complete a vlookup that does not spill into other fields.  How can I stop it?

5 Replies

@ShannonCallicott 

Use a correct VLOOKUP() formula.

There is only one VLOOKUP formula available to use.

@ShannonCallicott 

Function is only one, but it's infinite number of ways to use it. Plus similar functions as XLOOKUP, LOOKUP, INDEX/MATCH,..

@ShannonCallicott 

Maybe you are using one formula but obviously it is not a correct formula - hence the spilling.

 

@ShannonCallicott 

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?