Combining two formulas

[brooksc29]

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

 

[VoG]

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]

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

=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]

lol, beat by the MVP AGAIN!

 

[brooksc29]

works great MVP! Thanks!