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 |
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 |
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 |
All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com