+ Reply to Thread
Results 1 to 15 of 15

Single Cell Drop Down to Determine Data Sheet Lookup

Hybrid View

  1. #1
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,645

    Re: Single Cell Drop Down to Determine Data Sheet Lookup

    Hi again,

    Something else seems strange to me - the Usage-Cost Detail worksheet contains 78 rows of data (i.e. non Total / Subtotal rows), but a monthly worksheet contains only 76 rows of data. Where do the two extra rows of data come from?

    Also, in Rows (53:81) of the Usage-Cost Detail worksheet, is there a reason for the data row sequence being different from that of the monthly worksheet, or can the same sequence be used?

    Regards,

    Greg M
    Last edited by Greg M; 03-24-2016 at 07:51 AM. Reason: Second question added

  2. #2
    Registered User
    Join Date
    02-10-2009
    Location
    San Diego, CA
    MS-Off Ver
    Excel 365
    Posts
    30

    Re: Single Cell Drop Down to Determine Data Sheet Lookup

    So, the Detail sheet has 78 because of the two rows of subtotal for the individual Colo "Cage" space we have. Right now, each cage space has a different negotiated cost (hoping to fix that in the next few months).

    The row sequencing changes because of the way the Colo designates their space. Right now, they are in the process of changing up their naming conventions to match across all of their different co-location buildings (our cages are spread across two different buildings).

+ Reply to Thread

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