Trying to use Lookup with Named Columns
 

I have a price list with item numbers & decriptions in columns A & B followed
by 6 columns of possible price levels based on customer type and location
(i.e. North America List, North American OEM, etc)

I'm trying to create seperate tabs for each of the 6 price levels which
refer back to the main sheet. Simple enough, except I am attempting to use a
name or label instead of just a cell reference. I also don't know anything
about dynamic ranges.

Any help is greatly appreciated.
--
Sandy Controller

Trying to use Lookup with Named Columns
 

So what exactly is the problem Sandy. How to create the names, how to use
them, they give wrong answer?

Can you post what you have done to date, formulae, names etc.?

--
HTH

Bob Phillips

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

"San" wrote in message
...
I have a price list with item numbers & decriptions in columns A & B
followed
by 6 columns of possible price levels based on customer type and location
(i.e. North America List, North American OEM, etc)

I'm trying to create seperate tabs for each of the 6 price levels which
refer back to the main sheet. Simple enough, except I am attempting to
use a
name or label instead of just a cell reference. I also don't know
anything
about dynamic ranges.

Any help is greatly appreciated.
--
Sandy Controller