Forum Discussion

ShannonCallicott's avatar
ShannonCallicott
Copper Contributor
Oct 25, 2020

Formula Spill

I am needing to complete a vlookup that does not spill into other fields.  How can I stop it?
excel
ShannonCallicott's avatar
ShannonCallicott
Copper Contributor
Oct 25, 2020

There is only one VLOOKUP formula available to use.

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Oct 25, 2020

    ShannonCallicott 

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

     

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 25, 2020

    ShannonCallicott 

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