R
ryan
I'm trying to lookup a value where my lookup_values contain extra text.
e.g.
lookup_values = "Los Angeles, CA TOTAL
the table array will have Los Angeles, CA but not the word "TOTAL"
so, i'm lost somewhere at the beginning of the function. I know that i need
to remove the last six characters from my lookup_value, i'm not sure how.
please help.
thanks!
e.g.
lookup_values = "Los Angeles, CA TOTAL
the table array will have Los Angeles, CA but not the word "TOTAL"
so, i'm lost somewhere at the beginning of the function. I know that i need
to remove the last six characters from my lookup_value, i'm not sure how.
please help.
thanks!