<div>
This is for a dropdown list ... should have said that first. Also the actual error I am getting is &quot;The source currently evaluates to an error&quot;.
</div>


Data_validation_test---Ashish-solut.xlsm

<div>
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.<br />
<br />
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.<br />
<br />
When I put it together like =if(memberactive=&quot;yes&quot;,ful<wbr />lname or =if(memberactive,&quot;=yes&quot;,fu<wbr />llname) it does not work and gives me the error &quot;The source currently evaluates to an error&quot;.<br />
<br />
It works fine with =if(memberactive=&quot;yes&quot;,ful<wbr />lname ) when I have only one name in the list on sheet 1.
</div>


<div>
it would be easy if you just upload plz a dummy example of the file
</div>


<div>
Here is the sample of what I am doing<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/04_w15/1090620/Attendee-List-Plus---sample.xlsx" target="_blank" class="file-inline" title="Sample Excel File (63 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Attendee-List-Plus---sample.xlsx</a>
</div>


Attendee-List-Plus---sample.xlsx

<div>
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.<br />
<br />
I'm not clear what you are doing but it seems to me that filtering would work.<br />
<br />
Where are you putting the data validation list and where do you want the data extracting to?
</div>


<div>
The data validation is under the Name field on the Attendance Month 1 tab
</div>


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


<div>
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.
</div>


<div>
I came up with the best fix to the problem.
</div>


<div>
Sorry I've been really busy at work so I missed your reply. If you need further help just post back
</div>


<div>
<div class="content wysiwyg-content">
I am trying to create a data validation where if one value = yes then the second value is displayed.<br />
<br />
I have been using =if(memberactive=&quot;yes&quot;,ful<wbr />lname). Both named ranges on their own return the proper data but for some reason when I put it together it doesn't work. <br />
<br />
please help.
</div>
</div>


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.

Excel Data Validation issue

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.