| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
lookup part number and category and provide intersection price
=INDEX(A1:M100,MATCH(<partnumber,A1:A100,0),MATCH ("y",A1:M1,0))
<partnumber is part number. Within double quotes if text y is level.. If this post helps click Yes --------------- Jacob Skaria "Nelson" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
lookup part number and category and provide intersection price
On Mon, 17 Aug 2009 08:30:02 -0700, Nelson
wrote: 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 Try this formula: =INDEX(B2:M99,MATCH(X,A2:A99,0),MATCH(Y,B1:M1,0)) Replace X and Y with your values or references to cells where you X and Y values are. Hope this helps / Lars-Åke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup for Part of the number | Excel Discussion (Misc queries) | |||
| lookup a category for a part that contains a start and end value | Excel Worksheet Functions | |||
| lookup part number in a vertical list and return the most recent . | Excel Discussion (Misc queries) | |||
| LOOKUP FORMULA INTERSECTION OF A COLUMN AND (TWO) VALUES IN A ROW | Excel Worksheet Functions | |||
| Part Number Lookup | Excel Worksheet Functions | |||
Linear Mode
