On the 2nd tab of my spreadsheet, I have several dates in column A with
associated rates in Column B.

I entered a vlookup formula on Tab A that will find the corresponding rate
with the corresponding date, but how can I change the formula to pull the
rate closest to the date I'm looking for without going beyond it?

For example:
On tab A cell B1- I have 05/21/09

On tab B I have the following information:
5/10/09 5.25%
5/13/09 5.30%
5/18/09 5.32%
5/23/09 5.45%

Ideally, I'd like to have the fomula give me 5.32% as the answer.
How can I alter my vlookup formula, or is some other formula better?

Try in sheet1
=LOOKUP(B1,Sheet2!$A$1:$A$4,Sheet2!$B$1:$B$4)

If this post helps click Yes
---------------
Jacob Skaria


"Brian" wrote:

On the 2nd tab of my spreadsheet, I have several dates in column A with
associated rates in Column B.

I entered a vlookup formula on Tab A that will find the corresponding rate
with the corresponding date, but how can I change the formula to pull the
rate closest to the date I'm looking for without going beyond it?

For example:
On tab A cell B1- I have 05/21/09

On tab B I have the following information:
5/10/09 5.25%
5/13/09 5.30%
5/18/09 5.32%
5/23/09 5.45%

Ideally, I'd like to have the fomula give me 5.32% as the answer.
How can I alter my vlookup formula, or is some other formula better?

On Wed, 7 Oct 2009 05:51:01 -0700, Brian
wrote:

On the 2nd tab of my spreadsheet, I have several dates in column A with
associated rates in Column B.

I entered a vlookup formula on Tab A that will find the corresponding rate
with the corresponding date, but how can I change the formula to pull the
rate closest to the date I'm looking for without going beyond it?

For example:
On tab A cell B1- I have 05/21/09

On tab B I have the following information:
5/10/09 5.25%
5/13/09 5.30%
5/18/09 5.32%
5/23/09 5.45%

Ideally, I'd like to have the fomula give me 5.32% as the answer.
How can I alter my vlookup formula, or is some other formula better?


What do you mean by "rate closest to the date ... without going beyond it?"

What should 5/22/09 return?

If 5/22/09 should also return 5.32%, then VLOOKUP should do that.

e.g.: =VLOOKUP(B1,Tbl,2)

What kind of VLOOKUP formula are you using? What kind of problem are you
having with it?
--ron