Vlookup Question..if text lookup_value do not match with table
So, will it always be xx (and the xx-xx was just a typo), or might
there be more than just 2 x's?
Pete
On Jun 29, 6:19*pm, ldiaz wrote:
most common is like follow:
last 4 digits mean a project number, and the text that may change is 2
digits before that.
P-G-SHLD-LIM-LG-YK-5330
P-G-YOKE-YK-5390
P-TACTBAG-WG-5157
S-G-THROAT-WG-5200
example :
P-G-SHLD-LIM-LG-xx-5330
P-G-YOKE-xx-5390
P-TACTBAG-xx-5157
S-G-THROAT-xx-5200
remember that I need to mantain the condition to look up valus as this.
P-TACTBAG-YK
on a table array to find this:
P-TACTBAG-xx
Thanks
LD
--
Lorenzo Díaz
Cad Technician
|