# Index Match formula? Or something else?

#### MOB

##### Well-known Member
I need a formula that returns a value from columns C-F based on 2 criteria in columns A & B.

So an example using the below;

Bravo, Item 3 - should return 6,8,5,6 when I drag the formula across

I think its index match but unsure :-/

TIA

 A B C D E F 1 Alpha Item 1 1 3 4 9 2 Item 2 2 1 1 4 3 Item 3 8 2 8 8 4 Item 4 3 1 2 3 5 6 Bravo Item 1 4 1 1 4 7 Item 2 8 2 8 8 8 Item 3 6 8 5 6 9 Item 4 3 1 2 3 10 11 Charlie Item 1 1 4 4 1 12 Item 2 8 8 1 8 13 Item 3 5 6 8 5 14 Item 4 2 3 2 2

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### RAJESH NATH

##### Board Regular
practice.xlsx
ABCDEFGHIJKL
21AlphaItem 1Alpha Item 113491349
32AlphaItem 2Alpha Item 221142114
43AlphaItem 3Alpha Item 382888288
54AlphaItem 4Alpha Item 431233123
65
76BravoItem 1Bravo Item 141144114
87BravoItem 2Bravo Item 282888288
98BravoItem 3Bravo Item 368566856
109BravoItem 4Bravo Item 431233123
1110
1211CharlieItem 1Charlie Item 114411441
1312CharlieItem 2Charlie Item 288188818
1413CharlieItem 3Charlie Item 356855685
1514CharlieItem 4Charlie Item 423222322
Sheet6
Cell Formulas
RangeFormula
I2:L15I2=IFERROR(INDEX(E\$2:E\$15,MATCH(CONCATENATE(\$B2," ",\$C2),\$D\$2:\$D\$15,0))," ")
D12:D15,D7:D10,D2:D5D2=B2&" "&C2

I only put additional column i.e Column D

#### MOB

##### Well-known Member
Thanks Rajesh

Ideally I dont want to add a helper column, or have to copy down the names in column B

Makes it a bit trickier

Replies
7
Views
83
Replies
0
Views
41
Replies
3
Views
92
Replies
1
Views
46
Replies
5
Views
83

1,126,972
Messages
5,621,913
Members
415,865
Latest member
pxmike

### 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