Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select a particular number from a rage of number | Excel Worksheet Functions | |||
Drill-Down | Excel Discussion (Misc queries) | |||
drill down again | Excel Discussion (Misc queries) | |||
Sum by date rage using multiple sheets | Excel Discussion (Misc queries) | |||
Need help with a formula for calculating based on a rage of dates | Excel Discussion (Misc queries) |