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.

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

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.

m glad this worked for you pls mark thread as solved

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