I want to match and insert info on 2 different sheets

  • Thread starter Thread starter shanmac
  • Start date Start date
S

shanmac

Really embarassing newbie question:

I have two sheets of data, both sheet have a common identifier "school
code". One sheet has some results (numbers) for each school code that
I'd like to match to the school codes on the other sheet. I can't seem
to figure it out using "MATCH" or "VLOOKUP", what do I need to do?

Hope this is enough info. Thanks.
 
shanmac said:
I have two sheets of data, both sheet have a common identifier "school
code". One sheet has some results (numbers) for each school code that
I'd like to match to the school codes on the other sheet. I can't seem
to figure it out using "MATCH" or "VLOOKUP", what do I need to do?
Click to expand...

Try Debra's nice coverage on VLOOKUP or INDEX/MATCH:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study

Just my opinions .. INDEX/MATCH would usually be a more versatile option
compared with VLOOKUP which requires that the lookup column be the leftmost
col, albeit this may not be a problem if the key col in the mastersheet is
always the first col (say). We can also directly index the col to be
returned using INDEX/MATCH [eg INDEX(H:H, ...)] whilst with VLOOKUP, we need
to figure out ("count") the relevant col_index_num. But VLOOKUP is simpler to
understand, and usually shorter in construct. It's good to know and try out
both options.

---
 
Back
Top