I am working with a column of numbers that represent ½ hour intervals
(12:00AM, 12:30AM, 01:00AM, etc..., 11:30PM) that run from A11:A58.

This range of data serves as the X Axis for a chart showing performance in
the given interval.

HOWEVER

I must use the same template for multiple vendors and they have different
hours of operations (HOO).

Is there a way to do something like:
IF B2="Vendor1, Vendor4 or Vendor5"
Then let the range A21:A58 be named "HOO"
Else let the range A25:A52 be named "HOO"

OR

Can I use the INDIRECT or VLOOKUP to insert the X Axis range for me?

Yeah, use a formula like this to define the name with

=OFFSET($A$20,IF(OR($B$2="Vendor1",$B$2="Vendor4", $B$2="Vendor5"),1,5),0,IF(OR($B$2="Vendor1",$B$2=" Vendor4",$B$2="Vendor5"),38,26),1)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"RayportingMonkey" wrote in
message ...
I am working with a column of numbers that represent ½ hour intervals
(12:00AM, 12:30AM, 01:00AM, etc..., 11:30PM) that run from A11:A58.

This range of data serves as the X Axis for a chart showing performance in
the given interval.

HOWEVER

I must use the same template for multiple vendors and they have different
hours of operations (HOO).

Is there a way to do something like:
IF B2="Vendor1, Vendor4 or Vendor5"
Then let the range A21:A58 be named "HOO"
Else let the range A25:A52 be named "HOO"

OR

Can I use the INDIRECT or VLOOKUP to insert the X Axis range for me?