Is There Anyway to Do the Equivalent to VLOOKUP in Excel?

Questions & Suggestions
2

Yep, this can be easily done using RegEx.
See this example which you should be able to adapt for your use case:

MACRO: Replace Text with Numbers (or, Lookup Data Using RegEx) [Example)]