LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup using 2 cells as the "X" and "Y" coordinates.... kcsims Excel Worksheet Functions 1 December 15th 06 09:06 PM
Lookup tables and blank cells grant Excel Discussion (Misc queries) 2 November 11th 06 11:42 PM
is it possible to do lookup with cells containing tildes "~"? Steven Vegeta Excel Discussion (Misc queries) 9 October 9th 06 07:32 PM
Lookup formula - treat no-registered cells as blank gublues Excel Worksheet Functions 4 June 13th 05 10:32 PM
Skipping Blank Or Null Cells In a Lookup Function Bill Johnson Excel Worksheet Functions 8 December 24th 04 01:06 AM


All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"