#N/B error on Match/Index formula

[SteveNL86]

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.

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

 

[Fluff]

Are you selecting 10mm when you select 1530 x 3050, as that is the only size you have.

 

[SteveNL86]

Yes, I am.

 

[Fluff]

There's nothing wrong with the formula, so I suspect it's the data. Check for any extra spaces.

 

[SteveNL86]

As always you are a genius Fluff. For some reason there was a mistake in the data. Always great having to work with data others compiled for you, haha.

 

[Fluff]

Glad it's sorted & thanks for the feedback.