Topic: String Modification (Excel)

[ChrisCarlson]

VBA is not my strong suit but I have a string that I'm trying to parse information from.   

Code - vb.net: [Select]

1. =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?

[ChrisCarlson]

Disregard, went a different approach that seems to have worked.