| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Lookups
My apologies if this is a duplicate post.....
Maybe I should've done this to begin with, but here's my example From worksheet MAIN ALLEN, FRED ZAOP046145 COURSE Red COURSER12047 ALLEN, FRED ZAOP046145 COURSE Blue COURSEBL451815 ALLEN, FRED ZAOP046145 COURSE Yellow COURSEYEL014784754 ALLEN, FRED ZAOP046145 COURSE Green COURSEG654 ALLEN, FRED ZAOP046145 GREY Course GREY4578416 The above would be in one worksheet In another worksheet, let's say fred is beginning on row A2 I would like to display the results as such.. Results I would like to display NAME ID COURSE RED COURSE BLUE COURSE YELLOW COURSE GREEN GREY COURSE ALLEN, FRED ZAOP046145 COURSER12047 COURSEBL451815 COURSEYEL014784754 COURSEG654 GREY4578416 thanks... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookups | Excel Discussion (Misc queries) | |||
| Lookups | Excel Discussion (Misc queries) | |||
| Lookups or something | Excel Worksheet Functions | |||
| Maybe I need help with Lookups?? | Excel Worksheet Functions | |||
| LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Threaded Mode
