Hello. I am trying to look up alphanumeric values against an alphanumeric range.
I can do this against an all-number range, but can't figure out the alphanumeric equivalent. The challenge is that, because it is alphanumeric, I can't define a clear range for Excel.
In my numeric lookup, if the value 12345 appears in cell A2, I can return the value "Yes" because the vlookup range is defined.
=vlookup(A2,D2:F2,3,true)
<tbody>
</tbody>
In the alpha numeric version, I don't know what to put in the range, or how to have Excel find a partial match of an alphanumeric code.
An example of a value I am trying to find is: 0001234AD78D.
All of the alphanumeric values I want to find will start with 000123, and they (should) all be 12 characters long.
Suggestions?
I can do this against an all-number range, but can't figure out the alphanumeric equivalent. The challenge is that, because it is alphanumeric, I can't define a clear range for Excel.
In my numeric lookup, if the value 12345 appears in cell A2, I can return the value "Yes" because the vlookup range is defined.
=vlookup(A2,D2:F2,3,true)
D | E | F | |
1 | Low | High | Value |
2 | 12000 | 12999 | Yes |
<tbody>
</tbody>
In the alpha numeric version, I don't know what to put in the range, or how to have Excel find a partial match of an alphanumeric code.
An example of a value I am trying to find is: 0001234AD78D.
All of the alphanumeric values I want to find will start with 000123, and they (should) all be 12 characters long.
Suggestions?