Solved

# excel dropdown list selected vlookup to another value

Posted on 2014-09-18
276 Views
I have a workbook with a couple tabs and one has drop down lists that connects to other tabs to prefill the dropdown list.

so on my main tab column B is a drop down which selects data from TAB(Territory) Column A.  When the user selects on of the drop downs I also want Column C of the current tab to be filled with the corresponding Column B from Territory.  Is there a built in or vlookup?
0
Question by:Matt Pinkston
• 3
• 3

LVL 27

Expert Comment

Exactly...a VLOOKUP should suffice in this scenario.  If your data starts in row 2, insert this function in cell C2 and copy down:
=VLOOKUP(B2,Territory!B:B,1,FALSE)

Regards,
-Glenn
0

Author Comment

it is not brining the value from Territory Column B across when Column A is a match
0

LVL 23

Expert Comment

Maybe:

=VLOOKUP(B2,Territory!A:B,2,FALSE)
0

LVL 27

Expert Comment

My apologies... I was too quick to answer.  The formula should be:
=VLOOKUP(B2,Territory!A:B,2,FALSE)

Regards,
-Glenn
0

Author Comment

in column C I am hoping to get column B from territory when current tab Column B = Territory Column A
0

Author Comment

anyway to get rid of #N/A
0

LVL 27

Accepted Solution

Glenn Ray earned 500 total points
Yep:
=IFERROR(VLOOKUP(B2,Territory!A:B,2,FALSE),"")

This returns a blank cell if it can't find the value.  If you want another message, change the "" to "not found" or similar.

-Glenn
0

## Featured Post

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.