Formula Error

[Dastnai]

Hi Everyone,

I am extracting data from a column if I get an error, I pull the data from the other column. However, I need to drag this formula down those references have no values. So I get an error. I tried doing an if statement " " and IFERROR but I couldn't get it to work. Here is my current formula:

=IFERROR(TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("$",A1),3)," ",REPT(" ",100)),100)),TRIM(LEFT(SUBSTITUTE(MID(B1,FIND("$",B1),3)," ",REPT(" ",100)),100)))

Column A

$78 [Hold]

$78 [Hold]

11/28 ALLOCATIONS [Hold]

11/28 ALLOCATIONS [Hold]

11/28 ALLOCATIONS [Hold] Column B TEXAS SPECIALTY 1419159 BUEHLC $88 11/7/2018 TEXAS SPECIALTY 1419294 BUEHLC $80 11/8/2018 SCHLUMBERGER 1419282 FRANK $34 11/8/2018 SCHLUMBERGER 1419285 FRANK $39 11/8/2018 SCHLUMBERGER 1419289 FRANK $67.5 11/8/2018 Desired outcome: $78 $78 $34 $39 $67.5 Regards, Dastnai <colgroup><col></colgroup><tbody> </tbody> <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

 

[Eric W]

Try:

=IFERROR(TRIM(LEFT(SUBSTITUTE(REPLACE(A1&B1,1,FIND("$",A1&B1)-1,"")," ",REPT(" ",99)),99)),"")

 

[NdNoviceHlp]

I think its IsError. Something like...

=IF(ISERROR,"",(TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("$",A1),3)," ",REPT(" ",100)),100)),TRIM(LEFT(SUBSTITUTE(MID(B1,FIND("$",B1),3)," ",REPT(" ",100)),100))))
I have no idea if your formula is correct. HTH. Dave