Thread: [Solved] Lookup
View Single Post
 
Old 03-06-2015, 08:10 AM
lynette lynette is offline Windows 8 Office 2013
Novice
 
Join Date: Mar 2015
Posts: 4
lynette is on a distinguished road
Default

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
Reply With Quote