Results 1 to 7 of 7

Thread: selecting multiple criteria returning headers

  1. #1

    selecting multiple criteria returning headers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello Guru's

    From the example spreadsheet attached, I have tried using index and match, if statements, but to no avail, or maybe im missing something, but what im hoping to create is from the attached I havent included drop down menus, but I wanted to return the heading "contract term 1 etc.... if specific criteria were met from the drop down menu's.

    Can anyone help please......

    Many thanks.
    Attached Files Attached Files

  2. #2
    And with what criteria? not clear with you desired results

  3. #3
    Hi, thanks for your reply, I'm trying to return the headers when the user selects a painter from a drop down box, but if the data is blank then it will return a blank result, e.g. user selects painter 2 this will return all the column headers for painter 2.

    Thanks

  4. #4
    Maybe this help, please see the file
    Attached Files Attached Files

  5. #5
    Hi,

    Many thanks for the reply, it works like a treat, you are awesome, however, if i wanted to return the data rather than the column header, but use the drop down box and the column headers as the lookups, would I just use a standard index and match function even if there are blanks using the spreadsheet you have attached?

    Thanks

  6. #6
    Deleted Post
    Last edited by Rizky; 2014-05-02 at 02:22 AM.

  7. #7
    Yep done, I think you cant' use regular INDEX and MATCH, specially you have merged cell as criteria, thats painful for formula you know... please see attach file

    Regards
    Rizky
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •