Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
more re index and match
Was sent this formula by Double Z.. one issue with it... on my sheet 2 my
array is actually A1:N57 to match to the drop down list in E 11 on sheet 2( I am using info From A1:A57 store names sheet 2) then indexing same to match the date H3 sheet1 so that the info for Route # needed in I 13( Sunday to Saturday stored in H1:N57 on sheet two)will populate... problem is formula will not correctly match the selections after I get to entering Thursday in H:3 please help some more? =index(sheet2!$A$1:$D$50,match(sheet1!$E$11,index( sheet2!$A$1:$D$50,,1),0),match(sheet1!$H$3,index(s heet2!$A$1:$D$50,1,),0)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |