I want to match and insert info on 2 different sheets
 

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
------------------------------------------------------------------------
shanmac's Profile: http://www.excelforum.com/member.php...o&userid=36781
View this thread: http://www.excelforum.com/showthread...hreadid=564948

I want to match and insert info on 2 different sheets
 

"shanmac" wrote:
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?

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---