+ Reply to Thread
Results 1 to 7 of 7

formula that satisfies two conditions and search the name on the other tab.

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    The Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    9

    formula that satisfies two conditions and search the name on the other tab.

    I can hard to describe in English, but maybe you can see more in the atachmend. What I want is that if a2 is true and c5 is true that the name of the resident upon move. If Ms. weet1 member of testa1 and a2 is one room then put it on the list. WHEN a2 changed in 2 than the occupants of room 2. etc. I later make a userform to fill. the weekly calendar But I did not while the search formula needed and can not get out. Or it may be better with a macro?

    I volunteer for a nursing home for people with dementia. I have made ​​a whole database created with excel, so that the administration is easier. This is a new part of it.

    Hope you can help me Jean-Paul
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: formula that satisfies two conditions and search the name on the other tab.

    I have no idea what you are trying to achieve but try this in cell C6:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: formula that satisfies two conditions and search the name on the other tab.

    Hi jpgmaas , can you show an example answer you wish to get. I hard to understanding your workbook. Thanks
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  4. #4
    Registered User
    Join Date
    04-26-2013
    Location
    The Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: formula that satisfies two conditions and search the name on the other tab.

    This is a example what I try to get.
    This is what I want, I put the results in red. every time I change the room number only the members of that room must be on the list, so I wil sent a mail tot that room with the list of the week and thay can see witch persons must go to the activity.
    "testa1" in this example is a activity where they are members of. the activity also changed every day

    The members and the activity are standing in the tab verenigingen this is a small example the real contains 150 members and 50 activities, whe have 23 rooms with max 8 persons living there.

    I'll hope you understand it now a little better.

    JP
    Attached Files Attached Files
    Last edited by jpgmaas; 04-26-2013 at 09:12 AM.

  5. #5
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: formula that satisfies two conditions and search the name on the other tab.

    Agendasample(edIT).xls

    Is this OKIE?

  6. #6
    Registered User
    Join Date
    04-26-2013
    Location
    The Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: formula that satisfies two conditions and search the name on the other tab.

    Great thanks for your help, this is what I needed. thanks wenqq3

  7. #7
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: formula that satisfies two conditions and search the name on the other tab.

    Is great it helped!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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