Chances are good that your dates aren't really 'dates', either in your row 7
or in your actual vlookup. Most likely the trouble is with row 7, your dates
range. You can test this by typing the following in a blank cell above/below
your row 7. Assuming your dates actually start in B7
=ISNUMBER(B7), and copy across to column AE.
How are the dates in row 7 computed? I only ask because most people that go
from month A to month B don't go from 1/1/2009 to 2/2/2009 to 3/3/2009 etc.
They usually make everything one specific day of the month.

--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"dannyboy8" wrote:

John, still getting a n/a, what is incorrect w/ my formula below?

=VLOOKUP("project A",schedule,MATCH("1/1/2009",dates,0),0)

also, the names I have given to schedule and dates have ranges of A7:AE79
and A7:AE7 respectively, still no luck

"John C" wrote:

You might want to try a VLOOKUP with match instead:
=VLOOKUP(project name,$A$1:$M$13,MATCH(date,$A$1:$M$1,0),0)
This assumes your table with column and row headers is in cells A1:M13
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"dannyboy8" wrote:

am attempting to use the index and match functions to find the intersection
of project names and specific dates. The project names are along the rows in
the lefthand side and the dates are in one row across several columns. I have
set my index area, been able to match the project name using quotations, but
the formula will not let me return a column for the dates, I have tried
formattion the date, using quotations, but nothing will work. Can the MATCH
function be used with dates? Is there another formula to accomplish this? The
setup is as follows and as well as my formula, as always any help is most
appreciated

1/1/2009 2/2/2009 3/3/2009 4/4/2009
Project A
Project B
Project C

=INDEX(schedule,MATCH("Project A",project
list,0),MATCH("1/1/2009",dates,0))