Thread: [Solved] Lookup
View Single Post
 
Old 03-06-2015, 09:34 AM
Tony Singh Tony Singh is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Mar 2015
Posts: 8
Tony Singh is on a distinguished road
Default

Quote:
Originally Posted by lynette View Post
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.
Reply With Quote