+ Reply to Thread
Results 1 to 2 of 2

Can I link cells to a reference table I make?

  1. #1
    EZimm
    Guest

    Can I link cells to a reference table I make?

    I have a reference table where Grades are assigned a grade point value
    ex:
    A = 4.0
    A- = 3.67
    B+ = 3.33
    etc...

    I was wondering if I can reference this table from another cell so that the
    user can input the letter grade and it recognizes is as the grade point value?

  2. #2
    David McRitchie
    Guest

    Re: Can I link cells to a reference table I make?

    With a VLOOKUP table, see
    http://www.mvps.org/dmcritchie/excel/vlookup.htm
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "EZimm" <[email protected]> wrote in message news:[email protected]...
    > I have a reference table where Grades are assigned a grade point value
    > ex:
    > A = 4.0
    > A- = 3.67
    > B+ = 3.33
    > etc...
    >
    > I was wondering if I can reference this table from another cell so that the
    > user can input the letter grade and it recognizes is as the grade point value?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1