Results 1 to 16 of 16

Using multiple IF functions with VLOOKUP

Threaded View

codyryan Using multiple IF functions... 07-16-2021, 06:04 AM
AliGW Re: Using multiple IF... 07-16-2021, 06:09 AM
AliGW Re: Using multiple IF... 07-16-2021, 06:24 AM
codyryan Re: Using multiple IF... 07-16-2021, 06:38 AM
codyryan Re: Using multiple IF... 07-16-2021, 06:45 AM
AliGW Re: Using multiple IF... 07-16-2021, 08:39 AM
codyryan Re: Using multiple IF... 07-16-2021, 06:51 AM
JohnTopley Re: Using multiple IF... 07-16-2021, 07:17 AM
codyryan Re: Using multiple IF... 07-16-2021, 07:22 AM
JohnTopley Re: Using multiple IF... 07-16-2021, 07:30 AM
codyryan Re: Using multiple IF... 07-16-2021, 07:35 AM
JohnTopley Re: Using multiple IF... 07-16-2021, 07:35 AM
codyryan Re: Using multiple IF... 07-16-2021, 07:50 AM
JohnTopley Re: Using multiple IF... 07-16-2021, 08:02 AM
  1. #1
    Registered User
    Join Date
    12-10-2013
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2010
    Posts
    64

    Using multiple IF functions with VLOOKUP

    Hi I think this may be a tricky one, so I'd really appreciate any help. On the 'Cohort' tab in G5 I am trying to write a formula that will work out a grade based on what is in columns E2 and C5. I can do it for one specific combination of rules, but am struggling to work out how to make it apply to others. The combinations are as follows:

    E2 C5
    L F
    L H
    R F
    R H
    W F
    W H


    The L/R/W stand for 'Listening', 'Reading' and 'Writing'. The F and H stand for 'Foundation' and 'Higher'. The idea is that if a student, for example sits a Foundation Writing paper the VLOOKUP would look under the 'Ref' tab in columns W to Y to give out a grade from U to 5. Can this even be done with so many combinations?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to combine multiple IF functions with a VLOOKUP?
    By clogistics in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2016, 01:01 AM
  2. Not sure if I should use multiple vlookup, index or IF functions
    By nickiv in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-20-2013, 11:29 AM
  3. Multiple IF Functions or VLOOKUP functions
    By yinka00000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2012, 11:29 PM
  4. [SOLVED] Multiple if functions or vlookup
    By jmjulie25 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2012, 08:58 AM
  5. Using multiple IF, AND, VLOOKUP functions
    By kushal4698 in forum Excel General
    Replies: 9
    Last Post: 03-12-2012, 09:42 AM
  6. [SOLVED] if statements depending on multiple VLOOKUP functions
    By njuneardave in forum Excel General
    Replies: 1
    Last Post: 06-21-2006, 11:40 AM
  7. [SOLVED] Multiple IF & VLOOKUP functions
    By Serge in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-10-2006, 12:20 AM

Tags for this Thread

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