LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 69
Default lookup part number and category and provide intersection price

Good day, I have a pricing sheet that has part numbers (A2: A100), pricing
levels (B1: M1) and the pricing inbetween.

What would the formula be that says if if part number equals X and price
level is Y give me the intersecting price.

Thanks in advance

--
Nelson
--
Nelson
 
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
Lookup for Part of the number Kiran Excel Discussion (Misc queries) 3 April 9th 10 11:55 AM
lookup a category for a part that contains a start and end value winnie123 Excel Worksheet Functions 6 September 18th 08 08:22 PM
lookup part number in a vertical list and return the most recent . James T[_2_] Excel Discussion (Misc queries) 4 August 28th 07 09:07 PM
LOOKUP FORMULA INTERSECTION OF A COLUMN AND (TWO) VALUES IN A ROW SID Excel Worksheet Functions 1 February 10th 06 09:37 PM
Part Number Lookup Marshall2 Excel Worksheet Functions 2 July 11th 05 08:58 AM


All times are GMT +1. The time now is 08:03 AM.

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"