Quote:
Originally Posted by lynette
Have you tried IF statements? something like the following in the correct columns?
=IF(C2="CS",D2,) in the E2 cell
=IF(C3="FOOD",D3,) in F2
etc
then you would be able to copy the formulas
|
Thankyou Lynette, it worked just as I wanted.