Sorry but it doesn't seem to make sense, you have used the criteria that
you have explained but the section for 2009 is not populated?, what did
you populate manually for the given dates?

confused;432004 Wrote:
See attached for file. Here is an explanation of what I am trying to do.
In the "Amt by Year" tab, the user can select the criteria in cells
B3:B5 which contains a drop down list.
For example, the user selects Class = “A1”, Start Date = “5/28/09”, End
Date= “7/22/09”.

Given the three criterias above, I would like to populate the table
(see attached) using the “Data” tab information.

So in the table, cells A10:A17 are the names, and cells B8:AN8 are the
years, these will not change. I need excel to look up the Amount based
on the names and years that contains Class “A1”, “5/28/09” and
“7/22/09”, and populate the table accordingly.

I manually populated the table for you as to what the end result should
be.
Can a vlookup do something like this?

Thanks for your help


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119295