build data validation list that filters a tables 1st column and displays the same tables 5th column

%3CLINGO-SUB%20id%3D%22lingo-sub-1220916%22%20slang%3D%22en-US%22%3Ebuild%20data%20validation%20list%20that%20filters%20a%20tables%201st%20column%20and%20displays%20the%20same%20tables%205th%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1220916%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20at%20wits%20end%20trying%20to%20create%20a%20drop%20down%20list%20from%20the%20selected%20rows%20of%20field%20%22CardName%22%20based%20on%20%22ProcName%22.%26nbsp%3B%20I'm%20using%20Excel%202016.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176255iDCBC9C961B4B4608%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1220916%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1221447%22%20slang%3D%22zh-CN%22%3EReply%3A%20build%20data%20validation%20list%20out%20filters%20a%20tables%201st%20column%20and%20displays%20the%20same%20tables%205th%20col%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1221447%22%20slang%3D%22zh-CN%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578739%22%20target%3D%22_blank%22%3E%40recho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EDrop-down%20list%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20need%20to%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EData%2C%20data%2C%20%22clear%22%20%2C%20%22clean%22%20to%20work%20on%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1221461%22%20slang%3D%22zh-CN%22%3EReply%3A%20build%20data%20validation%20list%20out%20filters%20a%20tables%201st%20column%20and%20displays%20the%20same%20tables%205th%20col%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1221461%22%20slang%3D%22zh-CN%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578739%22%20target%3D%22_blank%22%3E%40recho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20feelings.%3C%2FP%3E%3CP%3ENeed%20to%20build%20a%20calculation%20in%20K-%20to%20judge%20first%3C%2FP%3E%3CP%3EWhether%20the%20column%20fits%20the%20%3CSPAN%3E%22ProcName%22%20message%3C%2FSPAN%3E%20you%20specify%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20the%20conforming%20K%20siouts%20%22Y%22%2C%20the%20non-conforming%20K%20out%20of%20%22N%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAnd%20then%20build%20a%20calculation%20in%20L-set%20%3CSPAN%3Eto%20determine%20%3CBR%20%2F%3E%20if%20K%20is%20%22Y%22%2C%20L%20%3CBR%20%2F%3E%20s%3C%2FSPAN%3E%20-%20E%20%2C%20no%20L%20%2C%20blank%20%2C%20and%20then%20set%20the%20L%20-%20as%20the%20clearing%20of%20the%20data%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1222137%22%20slang%3D%22en-US%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%20build%20data%20validation%20list%20that%20filters%20a%20tables%201st%20column%20and%20displays%20the%20same%20tables%205th%20col%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222137%22%20slang%3D%22en-US%22%3E%3CP%3EEnglish%20please..%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578919%22%20target%3D%22_blank%22%3E%40adlih%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I'm at wits end trying to create a drop down list from the selected rows of field "CardName" based on "ProcName".  I'm using Excel 2016.  

image.png

3 Replies
Highlighted

@recho 

下拉列表

需要在

資料> 資料驗證 > 選擇 "清單" > 選擇"範圍" 去製作

Highlighted

@recho 

 

你的情況

需要先在K欄創建算式去判斷

該列是否合符你指定的"ProcName"條件

如果合符 K欄出 "Y" , 不合符 K欄出 "N"

然後在L欄創建算式去判斷
如果 K欄 是" Y " , L欄 = E欄,  否則 L欄 = 空白
然後將 L欄範圍設置為 資料驗證的 清單範圍

 

Highlighted