Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert a cell based on its match with an adjacent cell? | Excel Worksheet Functions | |||
Complicated If Then / V Lookup / Match Statement... | Excel Worksheet Functions | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions |