View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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