Formula Spill

%3CLINGO-SUB%20id%3D%22lingo-sub-1816475%22%20slang%3D%22en-US%22%3EFormula%20Spill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816475%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20needing%20to%20complete%20a%20vlookup%20that%20does%20not%20spill%20into%20other%20fields.%26nbsp%3B%20How%20can%20I%20stop%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1816475%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1816509%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Spill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816509%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F845245%22%20target%3D%22_blank%22%3E%40ShannonCallicott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20a%20correct%20VLOOKUP()%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1816511%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Spill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816511%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20only%20one%20VLOOKUP%20formula%20available%20to%20use.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

5 Replies
Highlighted

@ShannonCallicott 

Use a correct VLOOKUP() formula.

Highlighted

There is only one VLOOKUP formula available to use.

Highlighted

@ShannonCallicott 

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

Highlighted

@ShannonCallicott 

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

 

Highlighted

@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?