INDEX/MATCH would be one good way .. You can match on any column, and return
any other column (to the left or right of the matching col) via the INDEX
part of it, eg to exact match a lookup value in A1 against col AZ & return
from col K would look like this:
=INDEX(K:K,MATCH(A1,AZ:AZ,0))

Try Debra Dalgleish's nice coverage on INDEX/MATCH at her page:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TracySLPS" wrote:
I am working with two worksheets of data which can be related based on a
common field between the two. I want to add data from one worksheet to the
rows of the other and i'm guessing I would do that based on the unique field
in both reports i.e. student ID number, but I dont know how to set this up. I
have Excel 2007. Help!