Question
 

Hi,
Please see below example of my question:


this yellow table is the source data (given):
HD2A 2775
HD5A 4010
HD6A 5105
HD8A 7460
HD10A 9540
HD14A 11080
HD20A 11080
HD15 15305




PHD2-SDS3 3610
PHD5-SDS3 4685
PHD6-SDS3 5860
PHD8-SDS3 6730




MSTC28 2760
MSTC40 3985
MSTC52 4740
MSTC66 5855




HD2 585
HD5 890
HD6 735



the green numbers are my input data and blue one are output data :
sample-1
2800 HD2A
PHD2
MSTC28


sample-2
8545 HD10A


sample-3
6325 HD8A
PHD6


sample-4
1500 HD2A
PHD2
MSTC28
HD2A


I need to compare green numbers with the numbers on the 2nd column (yellow
table) and obtain the blue names from the 1st column (yellow table) as you
see on above samples.

Thanks in advance.
Afshin K.
A-Design

Question
 

Oops the colors haven't appeared!
I'll try another way later.


"A-Design" wrote in message
...
Hi,
Please see below example of my question:


this yellow table is the source data (given):
HD2A 2775
HD5A 4010
HD6A 5105
HD8A 7460
HD10A 9540
HD14A 11080
HD20A 11080
HD15 15305




PHD2-SDS3 3610
PHD5-SDS3 4685
PHD6-SDS3 5860
PHD8-SDS3 6730




MSTC28 2760
MSTC40 3985
MSTC52 4740
MSTC66 5855




HD2 585
HD5 890
HD6 735



the green numbers are my input data and blue one are output data :
sample-1
2800 HD2A
PHD2
MSTC28


sample-2
8545 HD10A


sample-3
6325 HD8A
PHD6


sample-4
1500 HD2A
PHD2
MSTC28
HD2A


I need to compare green numbers with the numbers on the 2nd column (yellow
table) and obtain the blue names from the 1st column (yellow table) as you
see on above samples.

Thanks in advance.
Afshin K.
A-Design