Thread: lookup a category for a part that contains a start and end value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default lookup a category for a part that contains a start and end value
You can use wildcards with VLOOKUP. Give a few details of how your
data is laid out and what you want to do so that we can advise you
more fully.

Pete

On Sep 18, 3:18*pm, winnie123
wrote:
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?

Reply With QuoteReply With Quote