Line information pulled out base on date
I have a spread sheet with 4 columns named (Row3)::
Month End, Posted, Accrual, Amount.
Posted & Accrual columns are text and what I am looking for is that when a
date changes in A1 and matches a date under month end, I can get (in
separate cells) the correspondent value for posting Accrual and Amount.
a sample of one of the rows would be:
Month End Posted Accrual Amount
1/27/06 Feb06 25 days Mar06 10 days 25,500.00.
I appreciate your help with this.
fernando
Note: I tried to use index function but it does not work with text.
|