=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.