View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jennifer Jennifer is offline
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