VBA is not my strong suit but I have a string that I'm trying to parse information from.
=IFNA(VLOOKUP((IF(ISBLANK(Origin!$[b]C31[/b]),"-",Origin!$C31)),Data!$A:$A,1,FALSE), "ERROR")
Originally I used the Mid function but quickly realized its downside when dealing with a single digit cell reference. Is there a more ideal method for extracting C31 in this case but also accounting for C1 through C100 and beyond?