Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel (https://www.askmehelpdesk.com/showthread.php?t=748290)

  • May 10, 2013, 07:08 AM
    rodza
    Excel
    I have a problem. I have a list about some pupils and I have already linked them another tables as you told me (Because they are in different classes). But now I need to sort these pupils in the main table by their grades. If I do this, it will also effect to another tables, and there would be wrong information. So my question is that can I link by pupil's names? Thank you for your help in advance!
  • May 21, 2013, 07:13 AM
    JBeaucaire
    Yes, you can use the function VLOOKUP to look up a pupil's name in a table and bring back adjacent data about that pupil.

  • All times are GMT -7. The time now is 07:44 AM.