Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation and vlookup over 12 tables of data
Hello,
I hope someone can please please help me. I have 12 tables of data seperated by country, with each table showing sales each year for 10 years by product group. i.e A1 Cheese A2 Butter etc etc with the year across the top. What I want to do it have this data for each country on one worksheet with some sort of data validation drop down tool and a lookup so I can use the drop down to select a country and then the table for that country will appear below. I have tried a very basic vlookup which gave me the data for the first country but when I used another it came back with no data. Does anyone have an idea of how I can achieve this?? Thank you very very much if you can help. KR Joe W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up data validation and lookup tables...? | Excel Discussion (Misc queries) | |||
three data validation tables related to each other | Excel Worksheet Functions | |||
Data Validation vs VLOOKUP - Linking to data in a seperate file | Excel Worksheet Functions | |||
How to use both Vlookup & data validation | Excel Worksheet Functions | |||
can vlookup search multiple data tables | Excel Discussion (Misc queries) |