"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
---