# Combining two formulas

#### brooksc29

##### Active Member
How can I combine these two formulas so that the result shows a "/" in between?

=INDEX(AllDataP1,MATCH(A1,'TblDataP (1)'!\$A\$1:\$A\$100,FALSE),MATCH("SO",'TblDataP (1)'!\$A\$2:\$R\$2,FALSE))

INDEX(AllDataP1,MATCH(A1,'TblDataP (1)'!\$A\$1:\$A\$100,FALSE),MATCH("BB",'TblDataP (1)'!\$A\$2:\$R\$2,FALSE))

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

#### VoG

##### Legend
Try

=INDEX(AllDataP1,MATCH(A1,'TblDataP (1)'!\$A\$1:\$A\$100,FALSE),MATCH("SO",'TblDataP (1)'!\$A\$2:\$R\$2,FALSE))&"/"&INDEX(AllDataP1,MATCH(A1,'TblDataP (1)'!\$A\$1:\$A\$100,FALSE),MATCH("BB",'TblDataP (1)'!\$A\$2:\$R\$2,FALSE))

#### bjurney

##### Active Member
How can I combine these two formulas so that the result shows a "/" in between?

=INDEX(AllDataP1,MATCH(A1,'TblDataP (1)'!\$A\$1:\$A\$100,FALSE),MATCH("SO",'TblDataP (1)'!\$A\$2:\$R\$2,FALSE))

INDEX(AllDataP1,MATCH(A1,'TblDataP (1)'!\$A\$1:\$A\$100,FALSE),MATCH("BB",'TblDataP (1)'!\$A\$2:\$R\$2,FALSE))

Maybe

Code:
``=CONCATENATE(=INDEX(AllDataP1,MATCH(A1,'TblDataP (1)'!\$A\$1:\$A\$100,FALSE),MATCH("SO",'TblDataP (1)'!\$A\$2:\$R\$2,FALSE)) ,"/",INDEX(AllDataP1,MATCH(A1,'TblDataP (1)'!\$A\$1:\$A\$100,FALSE),MATCH("BB",'TblDataP (1)'!\$A\$2:\$R\$2,FALSE)))``

#### bjurney

##### Active Member
lol, beat by the MVP AGAIN!

#### brooksc29

##### Active Member
works great MVP! Thanks!

Replies
4
Views
206
Replies
0
Views
106
Replies
9
Views
106
Replies
9
Views
125
Replies
8
Views
84

1,128,018
Messages
5,628,176
Members
416,297
Latest member
Kara Payne

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