Need the cell next to one found through If Then
 

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

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

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