View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
San San is offline
external usenet poster
 
Posts: 14
Default 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