vlookup or index?

[kroemer]

Im trying to get two values from one spreadsheet that is associated with a name and put it into the new spreadsheet. i.e. i have well data; well name, x coord, y coord in one spreadsheet and the lab values from samples in another spreadsheet and i need to add the x an ys to the new spreadsheet but the wells names are not in any order.

any ideas?

thanks

[NBVC]

You should be able to use Vlookup for that.

e.g.

=Vlookup(A1,Sheet2!A1:C100,2,0) for x-coord

and

=Vlookup(A1,Sheet2!A1:C100,3,0) for y-coord

where A1 houses well name on current sheet
Sheet2!A1:C100 is the table of well data, where column B and C house the coordinates.

adjust ranges, sheetname as needed.

[kroemer]

i keep getting an error on the first A1

[kroemer]

It works, thanks