asked on

Excel Data Validation issue

I am trying to create a data validation where if one value = yes then the second value is displayed.

I have been using =if(memberactive="yes",fullname). Both named ranges on their own return the proper data but for some reason when I put it together it doesn't work.

please help.

Mark Wood

ASKER

This is for a dropdown list ... should have said that first. Also the actual error I am getting is "The source currently evaluates to an error".

SOLUTION

Professor J

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Mark Wood

ASKER

Let me explain this in detail. On sheet 1 I have the 2 named ranges FullName and MemberActive. On sheet 2 is where I need a single validation list that will pull the list of names where MemberActive = Yes.

If I go to sheet 2 and set the validation list to =FullName it will pull a list of all of the names, if I set it to =MemberActive it will pull a list of either Yes or No.

When I put it together like =if(memberactive="yes",fullname or =if(memberactive,"=yes",fullname) it does not work and gives me the error "The source currently evaluates to an error".

It works fine with =if(memberactive="yes",fullname ) when I have only one name in the list on sheet 1.

Professor J

it would be easy if you just upload plz a dummy example of the file

Mark Wood

ASKER

Here is the sample of what I am doing
Attendee-List-Plus---sample.xlsx

Roy Cox

I see you are using a Table which is good. However, using a Table you do not need to have unused rows, simply add them as required and the lists will expand.

I'm not clear what you are doing but it seems to me that filtering would work.

Where are you putting the data validation list and where do you want the data extracting to?

Mark Wood

ASKER

The data validation is under the Name field on the Attendance Month 1 tab

Roy Cox

When I change that the VLOOKUP formulas fill the rest of the row. What do you want to happen?

Mark Wood

ASKER

I am aware that vlookup fills in everything and under each day I will show the person as present etc. I just need the dropdown to show only the names of the people from the attendees tab where active = yes.

SOLUTION

Roy Cox

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Mark Wood

ASKER

perhaps

ASKER CERTIFIED SOLUTION

Mark Wood

membership