excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2598147%22%20slang%3D%22en-US%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2598147%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20drop%20down%20list%20for%20a%20cell%20and%20I%20want%20to%20add%20the%20second%20column%20to%20a%20different%20cell%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2598147%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2599177%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2599177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118635%22%20target%3D%22_blank%22%3E%40Don_Hampton_85%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20the%20data%20validation%20dropdown%20in%20cell%20A2%20has%20the%20range%20K2%3AK10%20as%20source%20list.%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20in%20B2%3A%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(A2%2C%24K%242%3A%24L%2410%2C2%2CFALSE)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a drop down list for a cell and I want to add the second column to a different cell,

1 Reply

@Don_Hampton_85 

Let's say the data validation dropdown in cell A2 has the range K2:K10 as source list.

Enter the following formula in B2:

=IFERROR(VLOOKUP(A2,$K$2:$L$10,2,FALSE)