Compare Coordinate Date

[PhillipA10]

Hello All,

I am trying to compare coordinate date from two separate sets of coordinates. Can someone please provide the formula to compare the Node Unique Name X and Y coordinates with the Column Unique Name X and Y coordinates and return the Column Unique Name (the data below the yellow highlighted cell). Any help would be greatly appreciated. Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2	1	10.25	11.25		15	12.25	13.25		1	18
3	2	12.25	13.25		16	14.25	15.25		2	15
4	3	14.25	15.25		17	18.25	19.25		3	16
5	4	16.25	17.25		18	10.25	11.25		4	19
6	5	18.25	19.25		19	16.25	17.25		5	17
Data

Cell Formulas
Range	Formula
G2:G6	G2	=F2+1
J2:J6	J2	=FILTER($E$2:$E$6,MMULT(--(VLOOKUP(I2,$A$2:$C$6,{2,3},0)=$F$2:$G$6),SEQUENCE(2,,,0)))

 

[PhillipA10]

Thank you for your quick response. The above formula worked great but I may have coordinate data with the same x or y values in the same column as shown in the below screenshot. If you get another chance, can you please provide the formula that would yield the results below the highlighted "Column Unique Name" column? Thank you.

 

[Fluff]

Can you please post the sample data, rather than an image.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[PhillipA10]

I've added the XL2BB Add-in. Below is the data that you requested. Thanks again!

Sample Coordinate Data.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Node Unique Name	X Coord	Y Coord		Column Unique Name	X Coord	Y Coord		Node Unique Name	Column Unique Name
2	1	10.25	35		15	10.25	20.25		1	17
3	2	55.25	100.25		16	99	65		2	18
4	3	99	65		17	10.25	35		3	16
5	4	99	35		18	55.25	100.25		4	19
6	5	10.25	20.25		19	99	35		5	15
Sheet1

 

[Fluff]

Thanks for that.
How about

=FILTER($E$2:$E$6,MMULT(--(VLOOKUP(I2,$A$2:$C$6,{2,3},0)=$F$2:$G$6),SEQUENCE(2,,,0))=2)

 

[PhillipA10]

That worked! Thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.