Dear reader,
I'm using this formula: =INDEX('List'!E5:E106;MATCH(1;('List'!B5:B106=B4)*('List'!C5:C106=C4)*('List'!D5:D106=D4);0))
On the sheet 'List' I have a list of Material in B, Size in C. Thickness in D and Price in E.
On my main sheet I'm using dependent dropdown boxes to select the material, size and thickness. And depending on those choices I want the correct price for the material.
So the formula is working, I'm getting the prices for every 1220x2440 material, but it gives me an #N/B error when I select the 1530 x 3050 size. I've tried sorting the columns but I can't get it too work.
Any help would be much appreciated.
Kind regards
I'm using this formula: =INDEX('List'!E5:E106;MATCH(1;('List'!B5:B106=B4)*('List'!C5:C106=C4)*('List'!D5:D106=D4);0))
On the sheet 'List' I have a list of Material in B, Size in C. Thickness in D and Price in E.
Material | Size | Thickness | Price |
Material A | 1530 x 3050 | 10 mm | € 68,75 |
Material A | 1220 x 2440 | 18 mm | € 93,35 |
Material A | 1220 x 2440 | 15 mm | € 73,00 |
Material A | 1220 x 2440 | 12 mm | € 57,95 |
Material A | 1220 x 2440 | 10 mm | € 45,00 |
Material A | 1220 x 2440 | 8 mm | € 44,90 |
Material A | 1220 x 2440 | 6 mm | € 32,00 |
Material A | 1220 x 2440 | 5 mm | € 32,00 |
Material A | 1220 x 2440 | 4 mm | € 24,50 |
On my main sheet I'm using dependent dropdown boxes to select the material, size and thickness. And depending on those choices I want the correct price for the material.
So the formula is working, I'm getting the prices for every 1220x2440 material, but it gives me an #N/B error when I select the 1530 x 3050 size. I've tried sorting the columns but I can't get it too work.
Any help would be much appreciated.
Kind regards