Find matching values and then paste a value

[jones1234]

Hello

I have 2 seperate datasets. The first one contains X coordinate, Y coordinate and elevation. The second one has X coordinate, y coordinate and 0 if a glacier is not present, 1 when present. What I want to do is paste the colom with 0 and 1 together with the first dataset if the coordinates match.

So for example:

Please Login or Register  to view this content.

Coordinates match in the first, second and last row (first colom): 12 15, 13 14 and 18 12, so there a 0/1 should be copied and pasted behind it.

I don't know how this can be done?

Thanks in advance!

[FDibbins]

Hi, welcome to the forum

I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.