SimonVOwen
New Member
- Joined
- Nov 15, 2017
- Messages
- 26
Good Morning All,
I am being very silly can anyone assist.
{=IFERROR(INDEX(sheet1!$D$2:$D$2872,SMALL(IF(sheet1!$C$2:$C$2872='Central Data'!$A2,ROW(sheet1!$D$2:$D$2872)),B$1)),"")}
I am using this array formula to pull data for another sheet, as there are multiple values present so i am dragging this formula across to pull out the 2nd/3rd results etc
{=IFERROR(INDEX(sheet1!$D$2:$D$2872,SMALL(IF(sheet1!$C$2:$C$2872='Central Data'!$A2,ROW(sheet1!$D$2:$D$2872)),C$1)),"")}
In this code the B1 / C1 are just referencing 1/2/3 etc as i believed this was pulling the 1st/2nd/3rd results.
This code is pulling out data however it is pulling the data from 1 row below the value i want..
What stupid thing have i done!
Thanks for any assistance.
Regards,
Disgruntled Muppet
I am being very silly can anyone assist.
{=IFERROR(INDEX(sheet1!$D$2:$D$2872,SMALL(IF(sheet1!$C$2:$C$2872='Central Data'!$A2,ROW(sheet1!$D$2:$D$2872)),B$1)),"")}
I am using this array formula to pull data for another sheet, as there are multiple values present so i am dragging this formula across to pull out the 2nd/3rd results etc
{=IFERROR(INDEX(sheet1!$D$2:$D$2872,SMALL(IF(sheet1!$C$2:$C$2872='Central Data'!$A2,ROW(sheet1!$D$2:$D$2872)),C$1)),"")}
In this code the B1 / C1 are just referencing 1/2/3 etc as i believed this was pulling the 1st/2nd/3rd results.
This code is pulling out data however it is pulling the data from 1 row below the value i want..
What stupid thing have i done!
Thanks for any assistance.
Regards,
Disgruntled Muppet