Matching and copying from two sets of column.

[celina1234]

I have a exel sheet with junction nodes on column D and entire database of junction nodes with their coordinates on F,G and H column.
i want to match the contents of column D with column F so that when a match is found it should give the junction node name along with the two coordinates.

for example :
in column D : in column F G and H
J_10 J_1 643070.955 2503771.775
J_100 J_10 642657.49 2502227.387
J_1000 J_100 642753.737 2495976.687
J_1002 J_1000 642294 2500066.007
J_1003 J_1001 641602.636 2500213.806
J_1004 J_1002 640827.384 2499931.77
J_1005 J_1003 641768.959 2499853.396
J_1006 J_1004 641527.545 2500170.47
J_1007 J_1005 641580.56 2499846.943
J_1008 J_1006 639440.498 2499605.116
J_1009 J_1007 641644.351 2499397.879
J_101 J_1008 642108.21 2499384.815
J_1010 J_1009 642023.749 2499419.741


it sholud be like

J_10 642657.49 2502227.387
J_100 642753.737 2495976.687
J_1000 642294 2500066.007
J_1002 640827.384 2499931.77
J_1003 641768.959 2499853.396
J_1004 641527.545 2500170.47
J_1005 641580.56 2499846.943
J_1006 639440.498 2499605.116
J_1007 641644.351 2499397.879

and so on.
Thanks .

[dilipandey]

for example :
in column D : in column F G and H
J_10 J_1 643070.955 2503771.775

Hi Celina, what part is for column H ?

Regards,
DILIPandey

<click on below 'star' if this helps>

[celina1234]

here is my exel sheet. please have a look at it.

column G and H is for node coordinates while F is the node name.

Selected nodes Node Database x coordinate y coordinates
col D col F col G col H

[dilipandey]

column G and H is for node coordinates while F is the node name.

I saw the file but found that column G and F are blank ...

Regards,
DILIPandey

<click on below 'star' if this helps>

[celina1234]

@Dilippandey
please download the file from the link and have a look. the priview may not be giving the whole picture. Thanks.

[dilipandey]

The comments in my post#4 are after downloading and seeing the file only from the link you gave, zipping and attaching that file here for you to check quickly :-

junction coordinates..zip

Regards,
DILIPandey

<click on below 'star' if this helps>

[celina1234]

oh am so sorry. My bad. the columns have got interchanged by mistake. instead of FGH it should be HI & J .
D col- selected nodes , H is the node database , I - x coordinate and J - Y coordinate.
Thanks.

[dilipandey]

Okay.. use the below formula in E1 and drag it to F1 and then down ..

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

[celina1234]

Thanks Dilip very much. That has solved my problem .

[dilipandey]

You are welcome Celina.

Suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>