Is there a way to search from the current location of a formula and up?

I'm using vlookup() to find a string of text, that may have more than one location, followed by a quantity. I want the quantity from the nearest location before the location of the formula.