Lookup and display values in order based on different date criteria.

**sandman85** · 08-13-2014, 02:19 AM

Hi,

I've been trying to pull data from a master table into smaller tables based on the date in the smaller week ending table. I have worked out the formula for the first table and this works
"=IF(ROWS(C$10:C10)>$B$13,"",INDEX('Project Mgmt Input Table'!D$8:D$1164,SMALL(IF(Table1[Week Starting]=$B$11,ROW(Table1[Activity Reference])-ROW('Project Mgmt Input Table'!$C$8)+1),ROWS(C$10:C10))))"

However when I apply this to subsequent tables, it doesn't pull the correct values. I have attached the document that I am working on and I'm sure I've overlooked something small but I can't seem to figure it out.

Any help would be greatly appreciated.

Cheers.

Plan Sheet 2.xlsx

**:) Sixthsense :)** · 08-13-2014, 02:26 AM

Column-C formula is Array formula Requires Requires CTRL+SHIFT+ENTER

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.