+ Reply to Thread
Results 1 to 3 of 3

Retrieve data from table - multiple conditions / conditions within conditions

  1. #1
    Registered User
    Join Date
    01-13-2016
    Location
    Poland
    MS-Off Ver
    2013
    Posts
    3

    Smile Retrieve data from table - multiple conditions / conditions within conditions

    Hi!

    I’ve got 3 tables:
    • 1st with codes and their 4 ordering codes
    • 2nd where you type one of the codes from 1st table and it returns its ordering codes (V.LOOKUP)
    • 3rd where you get all alternative codes of the chosen one (2nd table) but only with the same first ordering code.

    What I’m looking for:

    To get list of all alternative codes which ordering codes (one of them) match one of chosen code’s ordering codes.
    But only when ordering codes are not equal to ‘nd’ or ‘0’.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Retrieve data from table - multiple conditions / conditions within conditions

    Hi
    I do not know if is this you want
    Try these
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Retrieve data from table - multiple conditions / conditions within conditions

    Sorry, Post #2 is a mistake.
    Try that in B15 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Regards

+ 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. Replies: 2
    Last Post: 10-16-2014, 11:35 AM
  2. [SOLVED] Need to return data from a table based on multiple conditions
    By skayem in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-27-2014, 11:12 AM
  3. [SOLVED] Vlookup - Country conditions (Multiple conditions)
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2013, 11:42 AM
  4. [SOLVED] Text results with two conditions (lookup with two conditions)
    By Davzx in forum Excel General
    Replies: 8
    Last Post: 05-25-2012, 03:08 AM
  5. retrieve values on multiple conditions
    By Myth in forum Excel General
    Replies: 3
    Last Post: 07-29-2010, 05:02 AM
  6. Help with multiple conditions with lookup table
    By Paul Harris in forum Excel General
    Replies: 6
    Last Post: 11-09-2006, 09:19 PM
  7. [SOLVED] How to multiple conditions to validate more than 2 conditions to .
    By Bhuvana Govind in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2005, 04:06 PM

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