Coachmannyz8
New Member
- Joined
- Feb 28, 2018
- Messages
- 9
Good morning Forum ,
Here is my formula:
In 'Sheet 1' (cell J3)
=IFERROR(INDEX('Raw Data'!$B$3:$B$900,SMALL(IF(1=((--($D$6='Raw Data'!$A$3:$A$900))*(--($E$6='Raw Data'!$D$3:$D$900))),ROW('Raw Data'!$B$3:$B$900)-0,""),COLUMN()-1)),"")
my two criteria's are - "Position Title" & "Resource Number"
RAW Data (Sheet 2)
ROW B ROW C ROW D and so on
<tbody>
</tbody> 1 ID_389 Utilities
2 ID_389 Utilities
3 ID_389 Utilities
4 ID_389 Utilities
With the formula above, I'm trying to bring the data to cell 'J3' on Sheet 1 with the "Project" numbers "1,2,3,4".
Currently no data is present in cell J3; not sure if the -1 or -0 in the formula are the cause of the problem, but I changed the numbering system and no data seems to ever populate.
thank you for the assistance
Here is my formula:
In 'Sheet 1' (cell J3)
=IFERROR(INDEX('Raw Data'!$B$3:$B$900,SMALL(IF(1=((--($D$6='Raw Data'!$A$3:$A$900))*(--($E$6='Raw Data'!$D$3:$D$900))),ROW('Raw Data'!$B$3:$B$900)-0,""),COLUMN()-1)),"")
my two criteria's are - "Position Title" & "Resource Number"
RAW Data (Sheet 2)
ROW B ROW C ROW D and so on
Project | Cost Category | Resource Number | Project Line Number | ` | Position Title 1 |
<tbody>
</tbody>
2 ID_389 Utilities
3 ID_389 Utilities
4 ID_389 Utilities
With the formula above, I'm trying to bring the data to cell 'J3' on Sheet 1 with the "Project" numbers "1,2,3,4".
Currently no data is present in cell J3; not sure if the -1 or -0 in the formula are the cause of the problem, but I changed the numbering system and no data seems to ever populate.
thank you for the assistance