If you encountered the Excel spill error, you've come to the right place as we have prepared 3 solutions for you to implement ...
If your VLOOKUP formula needs a helper column, try DGET instead.