+ Reply to Thread
Results 1 to 2 of 2

Over thinking an Excel problem - Can I used Nested IF for this problem?

  1. #1
    Registered User
    Join Date
    10-31-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    9

    Over thinking an Excel problem - Can I used Nested IF for this problem?

    I think I am overthinking this and am fighting a migraine today. Please help. I have a summary worksheet that I want to use to display the current status of a project I am working on. That data is on a separate worksheet. I have four stages to display. On the summary tab I want the corresponding stage I am working on to reflect on that page. Hopefully I can explain in a way that makes sense. I have four people. They each have to go through four stages of an interview process. Once they complete each stage I put complete in the corresponding column. I want the summary page to look at those columns and see what stage they are in. Can I do this? I've attached the basic sheet. I actually have 500 people which is why I need this formula.

    Thanks!

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Over thinking an Excel problem - Can I used Nested IF for this problem?

    I do not see an attachment. I imagine you'd make use of LOOKUP to identify last status.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Over thinking an Excel problem
    By bdg724 in forum Excel General
    Replies: 3
    Last Post: 04-01-2015, 02:14 PM
  2. Nested IF problem, Excel Novice here!
    By natemoore9 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2014, 02:59 PM
  3. Problem with nested IF's and something else.
    By DominoEffect in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-29-2013, 11:21 AM
  4. Nested If problem!
    By Thu Rein in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2013, 06:12 PM
  5. nested if #n/a problem
    By penfold in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-09-2008, 08:51 PM

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