Add data based on a common field

  • Thread starter Thread starter TracySLPS
  • Start date Start date
T

TracySLPS

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count rows based on multiple criteria 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
sum if function 1
Pivot Table Field based on two data area fields 3
matching & combining data from seperate worksheets 2
Linking worksheets 1
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
merging two worksheets 3

Back
Top