Hello,

Is it possible to use a vlookup to reference a range of data, but not have
the exact value of the text you are looking up?

For instance: if I am looking up data in A1:A500. I know the lookup_value
has at least the text "Total". However, it turns out that in the range
A1:A500 the value I am looking for has the title "This is the Total"

As I began the question, I would like to use a vlookup to pull in a value
from this range, so I guess my basic question is how would I modify the
lookup_value or the table_array portion of the vlookup formula to make this
work?

Let me know if you need more info.

Thanks,