#1
|
|||
|
|||
Lookup
Hi
I am trying to automate entries (see attached) where all the information is entered on one side, upto the sum column, I then want the appropriate heading to automatically pick the sum in the same line. I would appreciate any help. Thanks Tony |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thankyou Lynette, it worked just as I wanted.
|
#4
|
|||
|
|||
No Problem! Glad it helped!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
It looks like a bug in Lookup command | Boyko | Excel | 5 | 01-30-2015 09:36 AM |
Lookup using 2 criteria | Itsbarbara | Excel | 16 | 10-07-2013 02:53 PM |
Lookup | angie.chang | Excel | 1 | 07-27-2012 09:45 PM |
Possible Lookup | Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
LookUp | aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |