Matching data from different tables

Hi everybody,

 

Please help me to solve the problem that worries me a lot. In one table I have two types of codes (numerical and letters) and in the second table only letter codes. How to recognize in the second table that the certain letter code matches the numerical table? PLEASE HELP ME!!! Thank you in advance.

Table 1:                  Table 2:

123   ABC               SDV

123   ABC               ABC

572   SDV               ABC

572   SDG              SDG

989   TTT               SDG

989   TTT                SDV

989   TTT                TTT

 

Sincerely,

Lena

 

By: Sladana

Leave a Reply

Your email address will not be published. Required fields are marked *