I have thousand of rows as follow:
Sheet1
Product STD-Code?
C-G-COL-YK
C-G-COL-YG
C-G-CRV-BICEP-YK
C-G-CRV-BICEP-PK
C-G-CRV-BICEP-YG
C-G-CRV-THROAT-YK
C-G-CRV-THROAT-YE
C-G-CRV-THROAT-EB
C-G-PGRN-WK
C-G-PGRN-WY
C-G-PGRN-WA
C-G-THIGH-LG-PK

and I have another list where it only shows one of each of family and I
replaced the digits that may change to ("xx"), where ("xx") means that the
value may change , example could be YK, YG, YB, PK, EB, LG, etc
Many Rows: C-G-COL-YG
Concentrated: C-G-COL-xx



Sheet2
Product STD-Code
C-G-COL-xx |Accy-90
C-G-CRV-BICEP-xx |Accy-90
C-G-CRV-THROAT-xx |Accy-40
C-G-PGRN-xx |Accy-40
C-G-THIGH-xx-xx |Accy-40

what I want ..is to put a vlookup that take the lookup_value for
example:C-G-COL-YK (located on sheet1) and take as table_array column Product
and STD-Code (Located in Sheet2) and the results that I want is "Accy-90" and
so on.


Could you please help me on this....

--
Lorenzo DÃ*az
Cad Technician