Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup from multipe cells
I need to extract some specific data from a large database. I would like to
have a separate worksheet that I can use for this, rather than using filters. I want to be able to specify the year wanted (located in Column A in the database) and the month wanted (located in column B in the database) and get the corresponding data in column G and H from the database. Oh, and the database is dynamic, it will be updated every month. In otherwords, I want to find all records for a specific month and year and then display just the data from columns G and H of those records. My intent is for someone who is not proficient in Excel to be able to type in the last report date (Month and Year) and find out Yes or No (Column G) for all ID's (Column H). I want ohave one box at the top for the user to type in the Month and Year and the resulting data to automatically show down below. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup from multipe cells
How many rows of data are in the database?
And, when you enter your search criteria, approximately how many results will be returned? What you want to do is not that difficult but the amount of data searched and returned can impact the performance. Biff "cmccurdy23" wrote in message ... I need to extract some specific data from a large database. I would like to have a separate worksheet that I can use for this, rather than using filters. I want to be able to specify the year wanted (located in Column A in the database) and the month wanted (located in column B in the database) and get the corresponding data in column G and H from the database. Oh, and the database is dynamic, it will be updated every month. In otherwords, I want to find all records for a specific month and year and then display just the data from columns G and H of those records. My intent is for someone who is not proficient in Excel to be able to type in the last report date (Month and Year) and find out Yes or No (Column G) for all ID's (Column H). I want ohave one box at the top for the user to type in the Month and Year and the resulting data to automatically show down below. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup using 2 cells as the "X" and "Y" coordinates.... | Excel Worksheet Functions | |||
Lookup tables and blank cells | Excel Discussion (Misc queries) | |||
is it possible to do lookup with cells containing tildes "~"? | Excel Discussion (Misc queries) | |||
Lookup formula - treat no-registered cells as blank | Excel Worksheet Functions | |||
Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions |