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
|