Coordinate triplets with point number

**gith** · 09-12-2012, 09:43 AM

So i'll start by saying that i'm pretty useless with excel beyond the basics, i'm sure that there is a simple way to do this but i've been through the forum and i've been through the help menus and i can't find the solution.

This is what i've got:

pt#|_x__|_y__|_z_
-------------------------------------------
p1 | 500 | 550 | 100
p2 | 400 | 450 | 150
p5 | 350 | 110 | 106

continues....

the point numbers are alpha numeric and may contain symbols (specifically underscores), the x value, y value and z value are all strictly numeric.

what i want to do is have a function that will search for (example) p2 and return the [x,y,z] triplet in seperate columns.

help!

Thanks a ton!
G

**ajm123456789** · 09-12-2012, 09:56 AM

in the column where you want the output,
for the x value use: =vlookup([click p1 cell], [highlight columns A-D], 2, 0)

assuming your data is in columns A-D

drag it down
for y and Z change the 2 to 3 and 4 respectively.
If you attach the file, I will be able to show better