Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX and MATCH functions
Danny,
Check out the "troubleshoot MATCH" section on this link. http://www.contextures.com/xlFunctions03.html -- If my posting was helpful, please click the "Yes" button. ROCK ON!, Scott "dannyboy8" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX and MATCH functions
Scott, it looks like when I click into the formula it is returning the right
row and column, but all the values returned are zero when I clearly see there are values in the sheet here's my formula, let me know if I need to change this: =INDEX(schedule,MATCH("Project A",'project list'!$B$1:$B$75,0),MATCH(--"12/5/2008",dates,0)) "porter444" wrote: Danny, Check out the "troubleshoot MATCH" section on this link. http://www.contextures.com/xlFunctions03.html -- If my posting was helpful, please click the "Yes" button. ROCK ON!, Scott "dannyboy8" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index and Match functions I think | New Users to Excel | |||
Row, Index, Match functions | Excel Discussion (Misc queries) | |||
INDEX & MATCH functions | Excel Worksheet Functions | |||
Index and Match Functions | Excel Worksheet Functions | |||
How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions |