I am trying to use a vlookup to take data from one worksheet to another, and
then get the data from another field on the second worksheet. To clarify,
the site id is a numeric field on the first worksheet. I want to use vlookup
to access a 2nd worksheet and vlookup that site id, but I want the output of
the equipment id on that same row, but located in a different column.

=VLOOKUP(site_id,Sheet2!A1:M10,3,False)

This assumes site_ids are in column A on sheet2, and you want the value from
column C.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"golfnut111" wrote in message
...
I am trying to use a vlookup to take data from one worksheet to another,
and
then get the data from another field on the second worksheet. To clarify,
the site id is a numeric field on the first worksheet. I want to use
vlookup
to access a 2nd worksheet and vlookup that site id, but I want the output
of
the equipment id on that same row, but located in a different column.

Basics

Sheet1 has the ID numbers in A1:A10

Sheet2 has the ID numbers in column A and the added data in column B

In B1 of Sheet1 enter =VLOOKUP(A1,Sheet2!$A$1:$B$10,2,FALSE)

Drag/copy down to B10

Or perhaps you want a DV dropdown in Sheet1 A1 to choose from.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP



On Mon, 18 Dec 2006 12:27:10 -0800, golfnut111
wrote:

I am trying to use a vlookup to take data from one worksheet to another, and
then get the data from another field on the second worksheet. To clarify,
the site id is a numeric field on the first worksheet. I want to use vlookup
to access a 2nd worksheet and vlookup that site id, but I want the output of
the equipment id on that same row, but located in a different column.

Gord Dibben MS Excel MVP