If your VLOOKUP formula needs a helper column, try DGET instead.
Turns out the A→Z button is just the beginning.