Results 1 to 15 of 15

Single Cell Drop Down to Determine Data Sheet Lookup

Threaded View

brafter70 Single Cell Drop Down to... 03-22-2016, 12:05 PM
Greg M Re: Single Cell Drop Down to... 03-23-2016, 10:43 AM
brafter70 Re: Single Cell Drop Down to... 03-23-2016, 12:35 PM
Greg M Re: Single Cell Drop Down to... 03-23-2016, 01:35 PM
brafter70 Re: Single Cell Drop Down to... 03-23-2016, 01:40 PM
Greg M Re: Single Cell Drop Down to... 03-23-2016, 01:47 PM
brafter70 Re: Single Cell Drop Down to... 03-23-2016, 01:48 PM
newdoverman Re: Single Cell Drop Down to... 03-23-2016, 07:04 PM
Greg M Re: Single Cell Drop Down to... 03-23-2016, 10:38 PM
brafter70 Re: Single Cell Drop Down to... 03-24-2016, 03:32 PM
newdoverman Re: Single Cell Drop Down to... 03-24-2016, 08:40 AM
brafter70 Re: Single Cell Drop Down to... 03-24-2016, 03:40 PM
brafter70 Re: Single Cell Drop Down to... 03-24-2016, 03:45 PM
Greg M Re: Single Cell Drop Down to... 03-24-2016, 03:52 PM
newdoverman Re: Single Cell Drop Down to... 03-24-2016, 04:10 PM
  1. #1
    Registered User
    Join Date
    02-10-2009
    Location
    San Diego, CA
    MS-Off Ver
    Excel 365
    Posts
    30

    Single Cell Drop Down to Determine Data Sheet Lookup

    Hello,
    I am trying to create a spread sheet that will allow me to trend and proof the invoice data from one of our Colo sites we use. I am able to download monthly usage data from their web portal. Based on a drop down selection in cell A1, I would like to have the main sheet populated with that corresponding months data (on a separate sheet) but utilized the lookups and formulas from that main sheet. So, if I select FEB 2016 from the drop down, I would like the data from sheet 02-2016 input into the main sheet that would have all of the formulas and lookups which would correspond to the selected sheet. Image below and spread sheet attached. Please let me know if you have further questions.

    Colo Excel.jpg

    Thanks in advanced for any help on this!

    Bryce
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple data selection from drop down list --> to single cell
    By Monami in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2014, 08:10 AM
  2. Replies: 5
    Last Post: 04-10-2014, 06:43 AM
  3. [SOLVED] multiple data in single cell lookup in another one data
    By vengatvj in forum Excel General
    Replies: 7
    Last Post: 11-09-2013, 01:45 PM
  4. How do I determine the languge in a single cell?
    By mhampshire in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2013, 02:08 PM
  5. Multiple lookup in a single cell with data validation
    By luckiest man in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-08-2011, 01:17 AM
  6. Multiple lookup in a single cell with data validation
    By luckiest man in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-08-2011, 01:02 AM
  7. Replies: 9
    Last Post: 07-15-2010, 11:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1