# Combining Formulas

##### New Member
I have 2 formulas that both work separately and I am wondering how I would go about combining them.

=IFERROR(INDEX('Edges & Hinderances'!\$B\$2:\$B\$95,SMALL((LEN('Edges & Hinderances'!\$A\$2:\$A\$95)>0)*ROW('Edges & Hinderances'!\$A\$2:\$A\$95)-MIN(ROW('Edges & Hinderances'!\$A\$2:\$A\$95))+1,ROW(A1)+ROWS('Edges & Hinderances'!\$A\$2:\$A\$95)-COUNTA('Edges & Hinderances'!\$A\$2:\$A\$95))),"")

=(TRIM(LEFT('Edges & Hinderances'!\$B\$2,SEARCH("(",'Edges & Hinderances'!\$B\$2&"(")-1))&""&'Edges & Hinderances'!\$A\$2&"")

So right now my result looks like Absolute Direction (1/3)

I am trying to have it pull Absolute Direction 1.

1 being the indicator that determines if it is pulling or not in the first formula.

I tried just putting them together and it gave me an error.=IFERROR(INDEX((TRIM(LEFT('Edges & Hinderances'!\$B\$2,SEARCH("(",'Edges & Hinderances'!\$B\$2&"(")-1))&""&'Edges & Hinderances'!\$A\$2&"")TRIM(LEFT('Edges & Hinderances'!\$B\$95,SEARCH("(",'Edges & Hinderances'!\$B\$95&"(")-1))&""&'Edges & Hinderances'!\$A\$95&""),SMALL((LEN('Edges & Hinderances'!\$A\$2:\$A\$95)>0)*ROW('Edges & Hinderances'!\$A\$2:\$A\$95)-MIN(ROW('Edges & Hinderances'!\$A\$2:\$A\$95))+1,ROW(E1)+ROWS('Edges & Hinderances'!\$A\$2:\$A\$95)-COUNTA('Edges & Hinderances'!\$A\$2:\$A\$95))),"")

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Replies
0
Views
227
Replies
3
Views
327
Replies
4
Views
210
Replies
1
Views
384
Replies
2
Views
195

1,196,013
Messages
6,012,857
Members
441,736
Latest member
Tkpmm

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