legalhustler
Wellknown Member
 Joined
 Jun 5, 2014
 Messages
 1,145
 Office Version

 365
 2016
 Platform

 Windows
I have a text string in column A and a 6 digit value in column B. I am trying to return the values in green.
..........................................Column A............................................................................Column B.........
201506 075 2473000610000000000000001298705828DE F017 ................................................610000
201506 075 2480000298500000000000002705814212DB F017 A .............................................298500
I have the following formula but it returns #Value error.
VLOOKUP(MID(A2,22,4),MID($A$2:$B$2,22,4),2,0)
This part of the formula MID(A2,22,4) is looking at the values in red.
Can someone help. And No I simply cannot do a mid of column A and get the 6 digit value b/c column B can have different values.
..........................................Column A............................................................................Column B.........
201506 075 2473000610000000000000001298705828DE F017 ................................................610000
201506 075 2480000298500000000000002705814212DB F017 A .............................................298500
I have the following formula but it returns #Value error.
VLOOKUP(MID(A2,22,4),MID($A$2:$B$2,22,4),2,0)
This part of the formula MID(A2,22,4) is looking at the values in red.
Can someone help. And No I simply cannot do a mid of column A and get the 6 digit value b/c column B can have different values.
Last edited: