Author Topic: String Modification (Excel)  (Read 372 times)

0 Members and 1 Guest are viewing this topic.

Master_Shake

  • Swamp Rat
  • Posts: 1381
String Modification (Excel)
« on: May 30, 2018, 10:46:10 AM »
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?

Master_Shake

  • Swamp Rat
  • Posts: 1381
Re: String Modification (Excel)
« Reply #1 on: May 30, 2018, 02:21:39 PM »
Disregard, went a different approach that seems to have worked.