Need help in Array Formula to pull data from other sheet

October 25, 2017 at 09:26:55
Specs: Windows 7
Hi
I need help from you guys again. I have a huge database on one sheet and I am creating a dashboard. There are several projects that master data sheet but I want to search in dashboard with project manager name (that i create a drop down list) and I want to pull the data in rows from master data where I have: Condition 1: Open projects (a column of open and close projects), Condition 2, Year 2017 (there is another column with year of projects). Applying following array formula but its not working.

=IF(ISERROR(SMALL(IF(IF(ISERROR(SEARCH($C$4,'2017 MF Database'!$C$5:$C$647)),FALSE,TRUE),ROW('2017 MF Database'!$C$5:$C$647)),ROW('2017 MF Database'!$H$5:$H$647))),"",INDEX('2017 MF Database'!$C$5:$K$647,SMALL(IF(IF(ISERROR(SEARCH($C$4,'2017 MF Database'!$C$5:$C$647)),FALSE,TRUE),ROW('2017 MF Database'!$C$5:$C$647)),ROW('2017 MF Database'!$H$5:$H$647)),6))

Also tried this, its seems like pulling some data but its not right either.

=IFERROR(INDEX('2017 MF Database'!$H$5:$H$647,SMALL(IF(Dashboard!$C$4='2017 MF Database'!$C$5:$C$647,ROW('2017 MF Database'!$H$5:$H$647)-2,""),ROW()-2)),"")

Plz help.


See More: Need help in Array Formula to pull data from other sheet

Reply ↓  Report •
Related Solutions


Ask Question