LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting different multiple columns rcg Excel Worksheet Functions 1 September 26th 06 05:58 PM
Lookup two different columns Sunryzz Excel Worksheet Functions 10 May 31st 06 06:11 PM
How can I sum data on a row from certain named columns? Liliana Excel Worksheet Functions 1 May 11th 06 08:07 PM
how do I lookup data based on two columns of data bttreadwell Excel Worksheet Functions 2 November 19th 05 03:54 AM
Lookup function skipping columns LaurenLa Excel Worksheet Functions 1 June 30th 05 05:55 PM


All times are GMT +1. The time now is 06:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"