Search up from current location?

[AMG300SD]

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.

[starguy]

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.

Hi
You should give some info. about about your data. Better is to attach a sample file in zip format.