Range and VLookup 2

[JPhilb]

I have a spreadsheet that lists a starting range in column A and the end range in column B. I have to then find the correct range that a certain customer is ranked and than take a seperate zoning number and line it up with its zoning amount.

EX-

A B Zone1 Zone2
10 19 10% 11%
20 29 15% 16%
30 39 20% 22.5%
40 49 25% 27.3% etc.


The table has several zone possibilities.
Thanks-
Jamie

 

[JVFriederick]

Assume the table as you describe is from A15
Place a value in cell A10, say 25
Place the word Zone2 in cell B10
Now copy and paste the following formula in C10

=VLOOKUP(A10,$A$2:$D$5,RIGHT(B10,1)+2,TRUE)

1. I'm using the number at the end of the Zone to help locate the column number
2. The TRUE parameter means the lookup numbers must be in ascending order (which they are - and likely will be)
3. You really don't need column B values.

It would be a good idea, and DaleWatson123321 will police me if I don't , to suggest a range name for the table. Then the formula will look like:

=VLOOKUP(A10,RateTable,RIGHT(B10,1)+2,TRUE)

 

[DaleWatson123321]

JV,

I would appear you're definitely on the right track, if not right on the mark.

I want to "ensure" that you get a "long deserved" STAR, and in the process, boost you to the next "80's plateau", which is long overdue. LOL LOL

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[JVFriederick]

Thanks.
What's up with all the new Emoticons ?
Feel like I'm in a supermarket walking the cereal isle.......
Oh well. Must admit a few are pretty good.

 

[JPhilb]

Thank you so much!
This actually worked.

Erica