Excel Gurus? - Technology - Contractor Talk

Excel Gurus?

 
Thread Tools Search this Thread Display Modes
Old 02-25-2017, 12:30 AM   #1
Member
 
Oklahomatyler's Avatar
 
Trade: Decks and Fences
Join Date: Dec 2015
Location: Claremore, Ok
Posts: 67
Rewards Points: 134

Excel Gurus?


Need some help with an excel sheet I'm making.

I created a drop down menu with different size material. I want another cell to populate with the price of said material when I click on it. How would I go about this?


Sent from my iPhone using Tapatalk
Oklahomatyler is offline  

Warning: The topics covered on this site include activities in which there exists the potential for serious injury or death. ContractorTalk.com DOES NOT guarantee the accuracy or completeness of any information contained on this site. Always use proper safety precaution and reference reliable outside sources before attempting any construction or remodeling task!

   

Advertisement

 

Old 02-25-2017, 12:42 AM   #2
I own stock in FotoMat!
 
480sparky's Avatar
 
Trade: 132 on Bush, I've got him at gunpoint!
Join Date: Jan 2009
Location: Iowa
Posts: 11,700
Rewards Points: 10,964

Re: Excel Gurus?


You want one cell to be the same as the cell you've added the drop-down choice in?

Equal function.

Advertisement

__________________
Due to circumstances beyond my control, I am here.
480sparky is online now  
Old 02-25-2017, 12:50 AM   #3
Hair Splitter
 
TNTSERVICES's Avatar
 
Trade: General
Join Date: Aug 2010
Location: Naperville, IL
Posts: 17,839
Rewards Points: 214

Re: Excel Gurus?


VLOOKUP Function.

https://www.extendoffice.com/documen...-populate.html
__________________
Tried & True on Facebook
Tried & True Website
Quote:
Originally Posted by CarpenterSFO View Post
You ask for your money frequently, and you collect it quickly, else you stop working immediately.
TNTSERVICES is offline  
The Following User Says Thank You to TNTSERVICES For This Useful Post:
Oklahomatyler (02-25-2017)
   
 
Old 02-25-2017, 12:50 AM   #4
Member
 
Oklahomatyler's Avatar
 
Trade: Decks and Fences
Join Date: Dec 2015
Location: Claremore, Ok
Posts: 67
Rewards Points: 134

Re: Excel Gurus?


No the drop down selection has names like PT or cedar I would like when I click on one it would populate the price into another cell that I can then do my math functions off whatever that cell is.




Sent from my iPhone using Tapatalk
Oklahomatyler is offline  
Old 02-25-2017, 12:52 AM   #5
Member
 
Oklahomatyler's Avatar
 
Trade: Decks and Fences
Join Date: Dec 2015
Location: Claremore, Ok
Posts: 67
Rewards Points: 134

Re: Excel Gurus?


Quote:
Originally Posted by TNTSERVICES View Post


Thank you!


Sent from my iPhone using Tapatalk
Oklahomatyler is offline  
Old 02-25-2017, 12:52 AM   #6
Hair Splitter
 
TNTSERVICES's Avatar
 
Trade: General
Join Date: Aug 2010
Location: Naperville, IL
Posts: 17,839
Rewards Points: 214

Re: Excel Gurus?



Advertisement

__________________
Tried & True on Facebook
Tried & True Website
Quote:
Originally Posted by CarpenterSFO View Post
You ask for your money frequently, and you collect it quickly, else you stop working immediately.
TNTSERVICES is offline  
The Following User Says Thank You to TNTSERVICES For This Useful Post:
hdavis (02-25-2017)


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Estimating with Excel for the Small Contractor YouTube cargin2 Business 123 01-13-2018 03:45 PM
Excel sheet for daily expenses Fishing4Life Business 3 01-10-2017 08:40 PM
excel help rotarex Technology 8 01-12-2014 08:48 PM
Excel material list festerized File Swap 4 08-14-2012 10:31 AM
Estimating Excel Spreed Sheets Soikie Technology 6 11-28-2011 10:11 PM

Join Now... It's Fast and FREE!

I am a professional contractor
I am a DIY Homeowner
Drywall Talk is for
PROFESSIONAL CONTRACTORS ONLY!

At DrywallTalk.com we cater exlusivly to professional contractors who make their living as a contractor. Knowing that many homeowners and DIYers are looking for a community to call home, we've created www.DIYChatroom.com DIY Chatroom is full of helpful advices and perfect for DIY homeowners.

Redirecing in 10 seconds
No Thanks
terms of service

Already Have an Account?