| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross referencing
I have a sheet that correspond students (Column A) to teachers (Column B).
On another sheet I have a list of items worked on by the students. This sheet has the student's name in Column A. I would like for it to populate the teacher's name in Column B. So on the item sheet, if row 5 was done by student Bob, I want B5 to show the name on Bob's teacher. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cross Referencing Data and Pasting | Excel Discussion (Misc queries) | |||
| Cross referencing data across different workbooks | Excel Discussion (Misc queries) | |||
| Minimum Value & Cell Cross Referencing | Excel Worksheet Functions | |||
| cross referencing | Excel Worksheet Functions | |||
| Cross workbook referencing based on cell input | Excel Worksheet Functions | |||
Threaded Mode
