Hello
In essence I am trying to bring the field/text "Test Handset 1 GB Total" from the Sample Data spreadsheet to the Sample PDF Reporting Spreadsheet
The current formula in the cell brings data across, however due to the nature of the data, there will be a lot of colours of the same products so have removed the colours so I can see the product as a whole
The formula I have is =IFERROR(INDEX('[Sample Data.xlsx]Sales Count Overview'!$B$2:$B$6,SMALL(IF(('[Sample Data.xlsx]Sales Count Overview'!$D$2:$D$6=E$4)*('[Sample Data.xlsx]Sales Count Overview'!$C$2:$C$6=E$1),ROW('[Sample Data.xlsx]Sales Count Overview'!$B$2:$B$6)-ROW('[Sample Data.xlsx]Sales Count Overview'!$D$2)+1),ROWS(B$1:B1))),"")
Not sure how or what to add to only return my required information
Thanks in advance!!
Bookmarks