Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2015, 02:03 AM
Tony Singh Tony Singh is offline Lookup Windows 7 32bit Lookup Office 2013
Novice
Lookup
 
Join Date: Mar 2015
Posts: 8
Tony Singh is on a distinguished road
Default 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
Attached Files
File Type: xlsx Summary.xlsx (9.8 KB, 3 views)
Reply With Quote
  #2  
Old 03-06-2015, 08:10 AM
lynette lynette is offline Lookup Windows 8 Lookup 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
  #3  
Old 03-06-2015, 09:34 AM
Tony Singh Tony Singh is offline Lookup Windows 7 32bit Lookup Office 2013
Novice
Lookup
 
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
  #4  
Old 03-06-2015, 11:03 AM
lynette lynette is offline Lookup Windows 8 Lookup Office 2013
Novice
 
Join Date: Mar 2015
Posts: 4
lynette is on a distinguished road
Default

No Problem! Glad it helped!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup 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
Lookup Possible Lookup Karen222 Excel 3 01-10-2012 05:41 AM
Lookup LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft