Drop Down and vlookup

[Miggy2021]

Evening all,

I have become stuck and I was hoping some experts could help me out?

I want to create a table that will have the user select a month from a drop down. Based on this month selection I then want values to return from a data list but not to bring across any duplicates only return one value.

I've attached a template to try to help with what I'm describing.

Is this possible please?

Thanks!

[Pete_UK]

Do you mean that you want to exclude duplicates if they appear within the selected month, or if they appear in earlier months?

Pete

[Miggy2021]

Hi Pete,

Yes I want to exclude the duplicates. So in the example of user selecting Oct-21 from drop down if Project A was listed three times I only want it to return one Project A.

Hope I'm explaining this ok 😕

Thanks again for taking the time to reply.

Paula

[Pete_UK]

For example, Project B appears in August, as well as September. If September is selected in C2 do you want to see Project B shown for that month, or not (because it appears in an earlier month)?

Pete

[Miggy2021]

Yes, exactly this. I want Project B to appear even is the user selects September or August from the drop down list. 👍🏻

[Pete_UK]

Okay, using column L as a helper column, put this formula in L3:

=IF(AND(J3=$C$2,COUNTIF(K$3:K3,K3)=1),MAX(L$2:L2)+1,"-")

Copy down to the bottom of your data. Then you can use this formula in cell C5:

=IF(ROWS($1:1)>MAX($L:$L),"",INDEX($K:$K,MATCH(ROWS($1:1),$L:$L,0)))

and copy that down as far as you need to.

If you do want to include projects that occur within the month selected (regardless of if they have occurred in earlier months), you can change the formula in L3 to this:

=IF(AND(J3=$C$2,COUNTIFS(K$3:K3,K3,J$3:J3,J3)=1),MAX(L$2:L2)+1,"-")

Hope this helps.

Pete

[Miggy2021]

This is amazing Pete. Thank you so much for helping me - works an absolute treat!

[Pete_UK]

That's good to hear. I think we had a few crossed posts earlier.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete