+ Reply to Thread
Results 1 to 3 of 3

Multi criteria search result to give unique answer

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    Chatteris uk
    MS-Off Ver
    Excel 2003
    Posts
    2

    Multi criteria search result to give unique answer

    Hi all, (newbie go easy)

    I have a table with say 6 columns by 5 rows, column A lists persons names, columns B, C D & E either have nothing in them or a y for yes, the last column F will display the result.

    What I'm trying to do is if person in A1 has a y in B1 and E1 then F1 will display, for example a text value which isn't calculated, it just means something to me, like C1/6 selected from a list
    if person A2 has a y in C2 only then F2 will display another text value, AA/3 for example, again from a list.

    Any pointers as to what to search for to allow me to do this.

    Thanks
    Last edited by redpis; 08-14-2013 at 02:10 AM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,503

    Re: Novice at work trying to get a table to deliver a result

    Hi redpis,

    Any chance you can upload a sample workbook with dummy data that shows what you have and what you need?

    Cheers.

    S.

  3. #3
    Registered User
    Join Date
    08-13-2013
    Location
    Chatteris uk
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Novice at work trying to get a table to deliver a result

    Hi S,

    The sample gives a rough idea, should have thought of uploading an outline earlier DOH
    Attached Files Attached Files

+ 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. Deliver a dashboard with powerpivot
    By diver360 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-18-2013, 05:28 PM
  2. [SOLVED] Novice trying to work how assign value in a cell based on another cell
    By jcartworx in forum Excel General
    Replies: 7
    Last Post: 08-30-2012, 01:30 PM
  3. Analysing sales data -pivot table novice
    By plainlazy84 in forum Excel General
    Replies: 3
    Last Post: 07-09-2008, 05:34 AM
  4. VBA To Deliver Object List?
    By (PeteCresswell) in forum Excel General
    Replies: 3
    Last Post: 05-21-2006, 10:38 PM
  5. search and deliver
    By damorrison in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-05-2006, 05:30 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