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 and MATCH functions

I 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 always any help is most appreciated

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

 
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
Index and Match functions I think Jim Butler New Users to Excel 9 November 25th 08 02:34 AM
Row, Index, Match functions Christopher Naveen[_2_] Excel Discussion (Misc queries) 1 September 20th 07 08:42 AM
INDEX & MATCH functions Iriemon Excel Worksheet Functions 2 August 28th 07 03:50 PM
Index and Match Functions Damien Excel Worksheet Functions 4 July 29th 06 10:12 PM
How do I use the Match and Index functions to look up a value tha. Maclanders Excel Worksheet Functions 7 February 10th 05 08:31 PM


All times are GMT +1. The time now is 09:27 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"