Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |