I’m looking under the tab disposition tracker. I am attempting to get it to return any of the three options from the dropdown in cell j5. I really need to create All in the list and it will give me all of the items from the dropdown. Thank you ahead of time.
Where do you want this, and what will it be based on?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I just need it to populate column A in the disposition tracker. It gets its data from helper 2 which gets its data from tissue log.
Here is my formula in A1 of disposition tracker. {=IFERROR(INDEX('Helper 2'!$A$2:$Q$2200,SMALL(IF('Helper 2'!$Q$2:$Q$2200=$J$5,ROW('Helper 2'!$Q$2:$Q$2200)-1),ROW(A1)),1),"")}. I can get the results for quarantined, returned and distributed. But I am trying to get one that will cover all 3.
Thanks again
Hi mahalek1976,
Try TRANSPOSE(Lists!$A$3:$A$5) instead of j5 inside the small-if.
Please Login or Register to view this content.
DMG
Deleted Duplicate
DMG
Last edited by dmg2016; 02-01-2017 at 09:22 PM.
Not sure I understand? You will have 1 item from the DD, but you want to be able to return 2 others as well?
If you want to have an "all" category, then maybe *** another helper column to Helper2 (I used R) and copy this down...
=IF(OR(Q2="quarantined",Q2="Distributed",Q2="Returned"),"all","")
Then for the formula to extract, try this ARRAY formula...
=IFERROR(INDEX('Helper 2'!$A:$A,SMALL(IF(IF($J$5="All", 'Helper 2'!$R$2:$R$2200,'Helper 2'!$Q$2:$Q$2200)=$J$5,ROW('Helper 2'!$Q$2:$Q$2200)),ROW(A1)),1),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks