A
A-Design
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
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