Solved

excel dropdown list selected vlookup to another value

Posted on 2014-09-18
7
276 Views
Last Modified: 2014-09-18
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
Comment
Question by:Matt Pinkston
  • 3
  • 3
7 Comments
 
LVL 27

Expert Comment

by:Glenn Ray
Comment Utility
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

by:Matt Pinkston
Comment Utility
it is not brining the value from Territory Column B across when Column A is a match
0
 
LVL 23

Expert Comment

by:NBVC
Comment Utility
Maybe:

=VLOOKUP(B2,Territory!A:B,2,FALSE)
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 27

Expert Comment

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

Regards,
-Glenn
0
 

Author Comment

by:Matt Pinkston
Comment Utility
in column C I am hoping to get column B from territory when current tab Column B = Territory Column A
0
 

Author Comment

by:Matt Pinkston
Comment Utility
anyway to get rid of #N/A
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now