# Thread: Double matching figures / or / double vlookup

1. ## Double matching figures / or / double vlookup

Register for a FREE account, and/
or Log in to avoid these ads!

Hi there,

I got 2 data sets containing x,y and z coordinates representing an ore seam.
The first data set has got many data points (1600 points) and represents one large floor surface of the seam.
The second data set has got only a few data points (50) and represents several smaller roof surface of the seam.
If in an area there are only floor coordinates, it means that there is actually no seam.
If in an area there are floor coordinates AND roof coordinates, the ore seam is present.
I want to find the ore seam.

 Floor Roof x y z x y z ... ... ... ... ... ... ... ... ...

So, for all the roof coordinates, I want to find the nearest floor coordinates. Since the z-coordinate can differ between the floor and the roof, we only need to focus on the x- and y-coordinates. I know the function =vlookup(), but I need a sort of double vlookup, where not only 1 coordinate, but both coordinates of a particular roof point are approximately near the floor point.

Who can help me with this?
It would be greatly appreciated!

Fido  Reply With Quote

2. It would help if you can post actual raw data samples and expected results (with explanatory notes as necessary).  Reply With Quote

3. Attached the Excel file.

In columns A B and C the x y and z coordinates of the floor.
In columns E F and G the x y and z coordinates of the roof.
For every data point of the roof, I want to find the point on the floor for which the x and y coordinates are the nearest.

Then the difference between the two depths (z coordinates) will give the thickness of the seam.  Reply With Quote

4. Hi fidodido

Can you not just import the coordinates into CAD (3D model) or put the X & Y on different layers and overlay!  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•