J
Jon
Hi,
I have two sheets as follows:
sheet1
A--------------B
34145 D173abcd
333215 TI242EFG
344233 E0124ABCD
Sheet2
A-----------B------------C
D-173 abcd ?
B-241 efgh ?
TI-242 XYZ ?
E-0124 STQ ?
What I want to do is taking the value from Colum A in sheet1 and put it in
column C in sheet 2 using Sheet1 Column B as an indicator.
Please note that the Column A in sheet2 has the same data of Column B in
sheet1 but there are extra letters and characters.
I have two sheets as follows:
sheet1
A--------------B
34145 D173abcd
333215 TI242EFG
344233 E0124ABCD
Sheet2
A-----------B------------C
D-173 abcd ?
B-241 efgh ?
TI-242 XYZ ?
E-0124 STQ ?
What I want to do is taking the value from Colum A in sheet1 and put it in
column C in sheet 2 using Sheet1 Column B as an indicator.
Please note that the Column A in sheet2 has the same data of Column B in
sheet1 but there are extra letters and characters.