Want to fine tune VLOOKUP formula given last week
Yes, but you have also modified the table so that where you had, for
example,
0.7500 1.50 before, you now have
=0.750 1.50
This is a totally different value to Excel (i.e. text, rather than
number), so your vlookup formula won't work.
Max's suggestion will allow your formula to "fill in the gaps", as it
were (well, with the original table), so that if a number is input
which is not in the table then the number below it will be taken
instead. Is this what you want?
Pete
|