+ Reply to Thread
Results 1 to 2 of 2

Formula to pull information based on information in different cells.

Hybrid View

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    41

    Formula to pull information based on information in different cells.

    Hello,

    I have a list where I have a main number and some of those main numbers have sub numbers. I have attached a copy of the spreadsheet that I am working on.

    Column O show the main numbers
    Column N show the reference to the main number and some sub numbers, For example, cell O3 (ABMS0075238) main reference number is 80601 (cell N3). Cell O22 (ABMS0610100) main reference number is 10100 but it also has sub numbers of 10102, 10103, 10104 and 10105.
    Basically, Main number in column O is the parent, the numbers (in italics) in column N are the children.
    Column Z show the evaluation outcome.

    Column AA has example of what I'd like the final outcome to be.
    The orange part is straight forward - there are no sub numbers, the outcome is what is in column Z.
    The green part, there are sub numbers but because column Z says 'Need Explanation', i'd like the formula to look at the sub numbers and if they're shown in column Z as evaluated (all the children), column AA would read 'Evaluated' and blanks would be entered in below for the sub numbers.
    The yellow part, becuase it shows a mix of outcome in column Z, I'd like column AA to show 'Evaluated with issues' and blanks below.

    Is this possible? I do apologize for the mass data. I think i've made this a bit too complicated and not sure what the next step is.

    THank you!!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Formula to pull information based on information in different cells.

    Is what I'm asking something that is impossible? I'm open to suggestions.

+ 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. Macro to Pull information from one Excel Sheet based on information in another sheet
    By IwannabanExcelGod in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 02:11 PM
  2. Replies: 5
    Last Post: 11-02-2012, 03:08 AM
  3. Pull information in one tab based on field in another tab.. HELP!
    By JanaA in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2008, 11:48 AM
  4. [SOLVED] Pull information based on a range of numbers
    By Styckz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2006, 02:15 PM
  5. [SOLVED] Pull information based on a range of numbers
    By Styckz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-17-2006, 03:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1