Home |
Search |
Today's Posts |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX w. MATCH function
I'd try:
=VLOOKUP("project A",schedule,MATCH(date(2009,1,1),dates,0),0) 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)) -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match and Index function | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
index match function help me | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Need help on index and match function | Excel Worksheet Functions |