Results 1 to 3 of 3

"Vlookup" with "IF"

Threaded View

  1. 07-29-2021, 02:49 PM #1
    alif_187
    alif_187 is offline
    Registered User
    Join Date
    11-10-2020
    Location
    London
    MS-Off Ver
    Microsoft Office 2021 Professional Plus
    Posts
    34

    "Vlookup" with "IF"

    Hi all,

    Thanks in advance to everyone who gives this a go.

    So basically I need a Vlookup with IF statement potentially.

    I have a list of students with unique id codes. Each student is assigned to a class however I need this data transferred over to a table.

    I've attached an excel document showing the list format and then the desired projected outcome.

    Thank you again to the person that assists with this.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Tried formula variations including "if", "sumif", "min", "match" but can't get it to work.
    By bjorn123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2020, 08:30 PM
  2. Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas
    By Windyz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  3. Using "index", "match", "min", "abs", to find the closest value in multiple criteria
    By escariojm in forum Excel General
    Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  4. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  5. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  6. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  7. [SOLVED] IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 01:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1