• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP with Drop Down Box

F

fish0321

New Member
I am using excel 2007. I am using the vlookup to help auto fill information into the work sheet. The problem I am having is that one for the cells I am auto filling has to be a drop down list so I can select between two options for the specific auto fill information. For example, I auto fill information about a person, which would include first and last name and other pertinent information. On one of the auto fill cells, I need to be able to select between two different numbers that is unique to that individual. I need to select on of two numbers that the individual is using for that day. The problem is that I do not know how to incorporate a drop down list as part of my vlookup formula. Basically I need to be able to auto fill all my information (which I have working fine) but also need to auto fill the cell that will allow me to choose between the specific numbers unique to that individual. any help would be great, thank you.
 
If it's just data validation, you can reference the cell in your vlookup.


If it's a VBA list box, you'll probably have to build a translation table.
 
Thanks Dan but once you reference the cell in vlookup, it dose not give you the option to choose what number you want in the cell. basically, i need to auto fill data via vlookup but in one of the cells, i need to choose between two numbers.
 
Try the data validation as suggested by Dan...


Just remember to uncheck the below...

On the Data Validation window


go to the Error Alert Tab

un-check Show Error alert after Invalid data is entered


Try this out and let us know..


~VijaySharma
 
Please ignore my above post... I was thinking off tanget..


Your requirement is to be able to Autofill all the entries basis some vlookup..


this is working fine for all other heading... however at one specific heading you need the vlookup to provide you with a dropdown list to choose between 2 values...


Please correct me if i am again travelling to other dimension here...


If i am correct... then please give some real life data to look at to be able to provide a solution...


~VijaySharma

sharma.vijay1@gmail.com
 
Fish,


Is vijay right? Are you trying to do set up data validation so that the list of possible entries is conditional?
 
Interesting question. I tried to solve this using a named formula that dynamically fetches the list of possible values for a drop-down based on what is selected in another drop-down. See this file: http://chandoo.org/img/playground/vlookup-drop-down-box-fish.xlsx


Examine the lstFeeOptions name to understand how it works. Notice the $B3, which is relative.
 
Just got the information and I am working on figuring it out now, from what I see it looks like what I am looking for. I am not an expert in excel so I just need to figure out the formulas. I gotta tell you, you guys are great and I really appreciate all the help and quick responses. I will let you all know how it turns out and if I run into a snag I will email a sample.


Thanks,

Fish0321
 
OK, cant figure out how to view the formula in your example Key Master. It is exactly what I am looking for but I can figure out how to view the lstFeeOptions format, plus how do you create the drop down list without a predefined list. bear with me guy, i know you are all putting me on the right path, I just have to dust off the cobwebs.


Thanks,


Fish0321
 
Fish0321

It is a Named Range

Goto the Formula, Name Manager Tab

Select lstFeeOptions

The formula will be shown at the bottom of the dialog

it is something like:

=INDEX(Sheet1!$P$3:$Q$12,MATCH(Sheet1!$B3,Sheet1!$M$3:$M$12,0),)
 
You must log in or register to reply here.
Back
Top