The situation I'm trying to solve for is very similar to #2 in this link: https://www.exceldemy.com/vlookup-if...text-in-excel/
Which is solved with this formula: =VLOOKUP(VALUE(LEFT(B13,3)),D4:E10,2,FALSE)
The only difference is that I will be using text (not numbers) and I don't want the lookup to be restricted to a certain # of characters (3 in the above example).
The value I want to lookup with will be the leftmost piece of the text string.
Any ideas?
Bookmarks