Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup / Match / Hlookup / Array fundtion or What?
I'm trying to tidy up 65,000 lines of student data ready to export into
another system. Our current spreadsheet has a sepearte line for each telephone number we have for each student (S1, S2 etc). So it currently looks like this: S1 Mob1 S1 Mob2 S1 Home1 S2 Office1 S3 Mob1 S4 Home1 S4 Office 1 S5 Mob 1 I want each student to have just a single entry (down the page) and then the type of number we have for them across the page, like this: Mob1 Mob2 Mob3 Home 1 Office1 S1 S2 S3 S4 S5 I need a function (or combo of moves) so that the spreadsheet goes and checks that we have (for example) a Mob1 for S1, or Mob2 for S1 and puts the right phone number in the right boxes. Any advcie / guidance on how to tackle this would be much appreciated. Thanks Winger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Vlookup, Index & Match | Excel Worksheet Functions |