fsjenkins2000
New Member
- Joined
- Feb 24, 2005
- Messages
- 7
i need help finding the right formula to find a specific text in colum A (Groceries) and then coresponding that to different value in the same row in a different column (D)>
A B C D E
catagory place depost withdarw total
Groceries wal-mart -150.00 1500.00
enter movies -18.00 1482.00
Groceries albertsons -100.00 1382.00
So i need a formula to find "Groceries" and corespond withdrawl amount in same row colum D. and place it off to the side or different workbook.
thanks for any help at all[/url]
A B C D E
catagory place depost withdarw total
Groceries wal-mart -150.00 1500.00
enter movies -18.00 1482.00
Groceries albertsons -100.00 1382.00
So i need a formula to find "Groceries" and corespond withdrawl amount in same row colum D. and place it off to the side or different workbook.
thanks for any help at all[/url]