I am trying to write a formula or VBscript that will accomplish this seemingly simple task:
In CELL A I want to enter a value, in this case the price of diesel fuel per gallon. I then want to compare that value against a table that contains 3 columns ABC and return a value base on that comparison, for example:
Current Diesel Price = x
if x is greater than w but less than y return value z. and if thats false check the next row in the table until true.
the lookup table looks like this
greater than less than charge %
1.00 1.05 14%
I need a single line for entry and a single result line, such as:
(user enters this value)
D.O.E. PRICE: 2.654
(formula returns this value)
FSC% 16.50%
I need it to look up the value from a table on another sheet formated as:
DOE Price
at least less than FSC%
2.31 2.32 14.0
2.32 2.33 14.1
2.33 2.34 14.2
2.34 2.35 14.3
2.35 2.36 14.4
2.36 2.37 14.5
2.37 2.38 14.6
Thanks for any help.
Bookmarks