LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 385
Default Dynamic Rage - Drill down

I have about 100 columns and the first two describe the numbers in all the
rest.

Looks like this:
BU 1 BU 2
Services Email 12 0
Services Phone 1 0
Services Ports 0 0
Services Desktop 0 7
Services Single Cable 1 1

Installation Single Cable 5 5
Installation Multi Cable 10 0

And on another worksheet I use VLookup to search for the BU and the 2nd
column description. Because there are repeated descriptions in different
groups I have to use a specific range in the VLookup function. The problem
comes with adding new rows. If the back end has added a new row the
worksheet won't catch it.

Is there a way to first match the first column and then look for the 2nd
column?

I can't change the first worksheet with the original data, it comes directly
from the back end.

This is what the other sheet looks like: (and where the VLookup is done)

(BU 1) Jan Feb ...etc.
Services
Email 12
Phone 1
Ports 0
Desktop 0
Single Cable 1

Installations
Single Cable 5
Multi Cable 10

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select a particular number from a rage of number Cazumel Excel Worksheet Functions 3 June 10th 08 07:38 AM
Drill-Down Eelinla Excel Discussion (Misc queries) 2 April 22nd 07 11:28 PM
drill down again [email protected] Excel Discussion (Misc queries) 3 January 24th 07 10:41 PM
Sum by date rage using multiple sheets Michael Excel Discussion (Misc queries) 3 March 24th 06 11:51 PM
Need help with a formula for calculating based on a rage of dates djeans Excel Discussion (Misc queries) 7 July 2nd 05 09:06 PM


All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"