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
[TABLE="width: 254"]
<colgroup><col></colgroup><tbody>[TR]
[TD] $78 [Hold][/TD]
[/TR]
[TR]
[TD] $78 [Hold][/TD]
[/TR]
[TR]
[TD] 11/28 ALLOCATIONS [Hold][/TD]
[/TR]
[TR]
[TD] 11/28 ALLOCATIONS [Hold][/TD]
[/TR]
[TR]
[TD] 11/28 ALLOCATIONS [Hold]

Column B
[TABLE="width: 372"]
<colgroup><col></colgroup><tbody>[TR]
[TD]TEXAS SPECIALTY 1419159 BUEHLC $88 11/7/2018[/TD]
[/TR]
[TR]
[TD]TEXAS SPECIALTY 1419294 BUEHLC $80 11/8/2018[/TD]
[/TR]
[TR]
[TD]SCHLUMBERGER 1419282 FRANK $34 11/8/2018[/TD]
[/TR]
[TR]
[TD]SCHLUMBERGER 1419285 FRANK $39 11/8/2018[/TD]
[/TR]
[TR]
[TD]SCHLUMBERGER 1419289 FRANK $67.5 11/8/2018

Desired outcome:
[TABLE="width: 300"]
<colgroup><col></colgroup><tbody>[TR]
[TD]$78
$78
$34
$39
$67.5

Regards,

Dastnai

[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]


[/TD]
[/TR]
</tbody>[/TABLE]


[/TD]
[/TR]
</tbody>[/TABLE]

 

[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