Need the cell next to one found through If Then

[workin4alivin]

Hello everyone...

I have a column in a worksheet that finds the latest date in a column (This
is the lastest paid date). Now, I want to have the amoutn paid which is in
the cell next to date paid to show

ie.
Date Amt pd Ck#
8/31/2004 ($25) 902 Last pymt 7/29/2005
9/18/2004 ($25) 914 Last pymt amt XXXXXXX
11/4/2004 ($25) 936
1/14/2005 ($50) 980
7/29/2005 ($100) 1070

I want XXXXXXX to show automatically $100

Thanks! Tara

[FSt1]

hi,
=LOOKUP(E3,A1:A20,B1:B20)

Assuming the date u want in in cell E3, this formula will look in range
A1:A20 and find date in E3 and return the value on the same row from range
B1:B20

Adjust the formula to fit your data.

regards
FSt1
"workin4alivin" wrote:

> Hello everyone...
>
> I have a column in a worksheet that finds the latest date in a column (This
> is the lastest paid date). Now, I want to have the amoutn paid which is in
> the cell next to date paid to show
>
> ie.
> Date Amt pd Ck#
> 8/31/2004 ($25) 902 Last pymt 7/29/2005
> 9/18/2004 ($25) 914 Last pymt amt XXXXXXX
> 11/4/2004 ($25) 936
> 1/14/2005 ($50) 980
> 7/29/2005 ($100) 1070
>
> I want XXXXXXX to show automatically $100
>
> Thanks! Tara

[workin4alivin]

Well, that would answer #2 from you! Thanks...it works brilliantly.

Tara

"FSt1" wrote:

> hi,
> =LOOKUP(E3,A1:A20,B1:B20)
>
> Assuming the date u want in in cell E3, this formula will look in range
> A1:A20 and find date in E3 and return the value on the same row from range
> B1:B20
>
> Adjust the formula to fit your data.
>
> regards
> FSt1
> "workin4alivin" wrote:
>
> > Hello everyone...
> >
> > I have a column in a worksheet that finds the latest date in a column (This
> > is the lastest paid date). Now, I want to have the amoutn paid which is in
> > the cell next to date paid to show
> >
> > ie.
> > Date Amt pd Ck#
> > 8/31/2004 ($25) 902 Last pymt 7/29/2005
> > 9/18/2004 ($25) 914 Last pymt amt XXXXXXX
> > 11/4/2004 ($25) 936
> > 1/14/2005 ($50) 980
> > 7/29/2005 ($100) 1070
> >
> > I want XXXXXXX to show automatically $100
> >
> > Thanks! Tara