LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 29
Default INDEX w. MATCH function

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))


 
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
Match and Index function Gary Reger Excel Worksheet Functions 2 February 15th 07 07:24 PM
index match array function-returning only first match, need last. Julie Olsen Excel Worksheet Functions 3 December 29th 06 12:50 AM
index match function help me vlookup help pls Excel Worksheet Functions 3 March 2nd 06 08:11 AM
Emulate Index/Match combo function w/ VBA custom function Spencer Hutton Excel Worksheet Functions 2 May 2nd 05 05:26 PM
Need help on index and match function Susan Hayes Excel Worksheet Functions 2 December 22nd 04 10:31 PM


All times are GMT +1. The time now is 11:54 AM.

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"