+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Lookup Tables ? in Technical; Hi, I want to assign grades in a sheet values: 8 -A* 7 -A 6 -B 5 -C and so ...
  1. #1
    jimbojames136's Avatar
    Join Date
    Mar 2011
    Location
    Hull
    Posts
    29
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Cool Lookup Tables ?

    Hi,

    I want to assign grades in a sheet values:
    8 -A*
    7 -A
    6 -B
    5 -C

    and so on........
    I'm guessing I need to use a lookup table of some sort, but I'm a complete novice using lookup tables so any pointers would be great.

    thanks

    James

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,578
    Thank Post
    1,473
    Thanked 1,227 Times in 835 Posts
    Rep Power
    753
    have a look at this example, hopefully it'll help
    Lookup_Example.xls

  3. Thanks to LosOjos from:

    jimbojames136 (25th March 2011)

  4. #3
    jimbojames136's Avatar
    Join Date
    Mar 2011
    Location
    Hull
    Posts
    29
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0
    perfect thanks



SHARE:
+ Post New Thread

Similar Threads

  1. Interactive Tables
    By loopylala in forum Hardware
    Replies: 2
    Last Post: 8th October 2009, 06:18 PM
  2. More league tables!
    By ServersPlus in forum General Chat
    Replies: 15
    Last Post: 30th July 2009, 12:24 AM
  3. Excel - Pivot Tables
    By danIT in forum Office Software
    Replies: 8
    Last Post: 8th May 2009, 06:13 PM
  4. Performance Tables
    By PhilNeal in forum MIS Systems
    Replies: 1
    Last Post: 8th September 2008, 11:02 PM
  5. Word 2003 Tables
    By Mintsoft in forum Windows
    Replies: 2
    Last Post: 26th May 2006, 12:24 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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