# #N/B error on Match/Index formula

#### SteveNL86

##### Board Regular

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

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Are you selecting 10mm when you select 1530 x 3050, as that is the only size you have.

Yes, I am.

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

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.

Glad it's sorted & thanks for the feedback.

Replies
2
Views
140
Replies
5
Views
1K
Replies
1
Views
2K
Replies
3
Views
324
Replies
8
Views
768

1,196,290
Messages
6,014,504
Members
441,825
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back