# determine a rate from a range of values based on a weekly fuel price

1. ## determine a rate from a range of values based on a weekly fuel price

I think this is pretty basic stuff. I need to determine a weekly fuel surcharge based on the price of fuel at a given point each week. Column C in my worksheet has been populated with price increments and Column D has been populated with the corresponding fuel surcharge for that increment. I want to enter the weekly fuel price in Column A, have the formula find the next lowest increment from Column C, and post the corresponding fuel surcharge from the adjacent cell of Column D into Column B adjacent to the cell where I entered the current fuel price.

2. ## Re: determine a rate from a range of values based on a weekly fuel price

HI Digoody9,

you can use below two formulas as suitable

in case array is fixed to mentioned column

=VLOOKUP(LOOKUP(A2,\$C\$2:\$C\$18),\$C\$2:\$D\$18,2,0)

in case its not fixed try below

=VLOOKUP(LOOKUP(A2,\$C\$2:\$C18),\$C\$2:\$D18,2,0)

Thanks
A

3. ## Re: determine a rate from a range of values based on a weekly fuel price

Thanks so much for speedy reply. That works like a charm! I used the first formula you offered, and it worked. When I have time, I'll educate myself on functions and arrays, but for now I really appreciate the help.

5. ## Re: determine a rate from a range of values based on a weekly fuel price

done ... I'm a new user, this is my first thread so I didn't know to do that. Thanks again!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1