Vlookup help

[tam76131]

Hello,

I have a data pull & would like to create a form so when I choose certain criteria it would automatically goes to my data pull & display what was being asked. For example in Cell A1 I would have a drop down menu with a specific month....whatever month the user choose information will send back to the data sheet to grab that information and display from row 6-10 on the summary page....please help. Thanks

[Bob Phillips]

Look at VLOOKUP in Excel Help.

[tam76131]

Thanks for all your help.

[tam76131]

i'm actually using vlook up right now...do you think vba would be better? Quicker & cleaner?

[Bob Phillips]

No, I can't see that it is necessary in this case.

[tam76131]

thanks

[tam76131]

XLD,

Similar data pull as the previous file....only this time it would have more details....for example...within West we would have all states in the west...within those western states we would have different cities. I would like to have a summary sheet where where I would have several options to choose from..for example when I choose West...it would display all states & cities in the west...and when I choose Traffic it would show me all the states & cities that have traffic...see attachment.

thanks XLD

[Bob Phillips]

I would have started a new threda for this.

But anyway, dependant data validation shuld do this. See http://www.contextures.com/xlDataVal02.html

[tam76131]

xld,

your link is very helpful...but what I would like to do is when I choose Fruit it would give me a list of all fruits (rather than in a drop down menu) that's currently in the database with their inventories by month for example
Jan Feb Mar
Fruit:
Apple 20 30 10
Orange 5 10 0
Peach 0 40 50

[lucas]

Hi Tam.....couple of points.
As Bob has pointed out you should really have started a new thread for this new question....

I changed the title of your thread from "Help" which is not very helpful when searching the forum, nor is it helpful to those that might want to take a look at your problem...please title your threads appropriatly, otherwise every thread would be titled "Help"

[tam76131]

sorry guys...this is my first time here :dunno

[lucas]

No problem....just want you to understand that what you do and how you post can make it harder or easier for those trying to help you.

[lucas]

As for your problem, I would suggest a userform with a combobox to select fruit and then from that populate a listbox from a range on the sheet.....possibly.

[charlesmklee]

Thanks for the help Very Usefull
:mbounce: