Offset Help

J

johns99

Board Regular
Joined
Jun 11, 2013
Messages
223
Office Version
  1. 365
Platform
  1. Windows
Hi, I'm trying to create a dependent drop-down list, but am having some issues. The offset formula I'm using in the below cell is pulling "Territory Company" and "ACE", it should only be pulling in "Territory Company". What am I missing here?

Thanks in advance.

John


Safety_LevelSafety_Identifier
Total CompanyTotal Company
Total CompanyTotal Companysftylvlstart=$A$1
Total CompanyTotal Companysftylvlcol=$A$2:$A$108
ACEACE
Region02
Region07
Region11=OFFSET(sftylvlstart,MATCH($H23,sftylvlcol,0),1,COUNTIF(sftylvlcol,$H23),1)
Region18
Region21Total CompanyTotal Company
Region26Total Company
Region28Total Company
Region36ACE
Region40
Region52
Region53
Region55
S&LS&L
TerritoryT002
TerritoryT003
TerritoryT004
TerritoryT005
TerritoryT006
TerritoryT007
TerritoryT008
TerritoryT009
TerritoryT010
TerritoryT011
TerritoryT012
TerritoryT013
TerritoryT014
TerritoryT015
TerritoryT016
TerritoryT017
TerritoryT018
TerritoryT019
TerritoryT020
TerritoryT021
TerritoryT022
TerritoryT023
TerritoryT024
TerritoryT025
TerritoryT026
TerritoryT027
TerritoryT028
TerritoryT029
TerritoryT030
TerritoryT031
TerritoryT032
TerritoryT033
TerritoryT034
TerritoryT036
TerritoryT037
TerritoryT038
TerritoryT039
TerritoryT040
TerritoryT041
TerritoryT042
TerritoryT044
TerritoryT045
TerritoryT046
TerritoryT048
TerritoryT049
TerritoryT050
TerritoryT051
TerritoryT052
TerritoryT053
TerritoryT054
TerritoryT055
TerritoryT056
TerritoryT057
TerritoryT058
TerritoryT059
TerritoryT060
TerritoryT061
TerritoryT062
TerritoryT063
TerritoryT064
TerritoryT065
TerritoryT066
TerritoryT067
TerritoryT068
TerritoryT069
TerritoryT070
TerritoryT072
TerritoryT073
TerritoryT074
TerritoryT075
TerritoryT076
TerritoryT077
TerritoryT078
TerritoryT079
TerritoryT080
TerritoryT081
TerritoryT082
TerritoryT083
TerritoryT084
TerritoryT085
TerritoryT086
TerritoryT087
TerritoryT088
TerritoryT089
TerritoryT090
TerritoryT091
TerritoryT092
TerritoryT093
TerritoryT094
Total CompanyTotal Company
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
You must log in or register to reply here.

Forum statistics

Threads
1,215,193
Messages
6,123,566
Members
449,108
Latest member
rache47

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top