LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 129
Default lookup a category for a part that contains a start and end value

Can anyone help? I have a worksheet containing part numbers and I want to
search another workbook which contains a product category. The trouble is the
product category only shows the first part number and last part number, its
not a full list. How can I use look up to return the product category?
 
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
Filter / Lookup: Display record on new sheet based on category... MeatLightning Excel Discussion (Misc queries) 1 April 14th 08 12:58 AM
2-part LOOKUP...t'were it possible? Arlen Excel Discussion (Misc queries) 4 October 27th 07 05:43 PM
Macro or Lookup? Not sure where to start. DoubleD New Users to Excel 1 September 1st 07 11:16 PM
Column chart - category axis - make to start with the second label Marko Pinteric Excel Discussion (Misc queries) 3 April 10th 06 09:31 AM
Column chart - category axis - make to start with the second label Marko Pinteric Charts and Charting in Excel 3 April 10th 06 09:31 AM


All times are GMT +1. The time now is 01:06 AM.

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

About Us

"It's about Microsoft Excel"