Thanks for your response.

What I need to do is lookup an account number in my database, return
the value for a specified column where the year equals a certain year.

For example, I want the value for an account number for March where the
year equal 2006.

I'm attaching an example workbook.

The first tab is my "report" (the worksheet where I want to get my
desired result).

The second tab is an example database where I want to pull my data
from.

The third tab is where I might put some "criteria" if using a database
function (DGET or DSUM).

The account number is not a fixed item that I can put under a criteria
column heading. That's my problem. Only the year would work for me
under a criteria heading.

Any help would be appreciated.


+-------------------------------------------------------------------+
|Filename: Example Data.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4909 |
+-------------------------------------------------------------------+

--
jaybird2307
------------------------------------------------------------------------
jaybird2307's Profile: http://www.excelforum.com/member.php...o&userid=35577
View this thread: http://www.excelforum.com/showthread...hreadid=553411