+ Reply to Thread
Results 1 to 7 of 7

How to make a condition that suite all 5 title before output an answer on other column

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    68

    How to make a condition that suite all 5 title before output an answer on other column

    Here's an example of workbook,i need it to be able to get value from sheet 1 to sheet 2 and there are also some that has similar nsid nsspec flowtype and tester and handler so this means that i could have a value like this:
    NSID Ldbd
    a 1
    a 2
    a 3
    I need different value if let say nsid a ldbd value 1 is taken it will take another but with condition that it must match all 5 criteria before output second value on ldbd.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-14-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: How to make a condition that suite all 5 title before output an answer on other column

    Anyone having problem what i meant?
    Last edited by zackdy; 11-19-2013 at 08:23 AM.

  3. #3
    Registered User
    Join Date
    11-14-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: How to make a condition that suite all 5 title before output an answer on other column

    If no one understand pls do tell me i will explain futher about what i need.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: How to make a condition that suite all 5 title before output an answer on other column

    I don't quite understand, but try:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    11-14-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: How to make a condition that suite all 5 title before output an answer on other column

    Protonleah yeah thats what i wan but how the sheet 2 F6 dont have value in it when sheet 1 F6 has value??

  6. #6
    Registered User
    Join Date
    11-14-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: How to make a condition that suite all 5 title before output an answer on other column

    Oh nothing dy i see cause it doesnt have any flowtype thats why no value

  7. #7
    Registered User
    Join Date
    11-14-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: How to make a condition that suite all 5 title before output an answer on other column

    Proton how about i send u the full file instead cause that way u will understand better what i need?what ur email i will send it there?

+ 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] macro to compare two columns, and then output an answer into a different column.
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 09:50 AM
  2. Replies: 3
    Last Post: 05-29-2013, 12:43 PM
  3. [SOLVED] For how long is it possible to change thread title? Answer: more than 2 hours!
    By Søren Larsen in forum Suggestions for Improvement
    Replies: 7
    Last Post: 04-18-2012, 06:48 AM
  4. Replies: 1
    Last Post: 04-02-2008, 12:03 AM
  5. how do i add 2 columns to make the answer apper on the 3rd column
    By merrymeet2u in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-31-2006, 12:10 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