bradyman97
New Member
 Joined
 Feb 22, 2008
 Messages
 46
 Office Version

 2019
I need some help with this formula. I need this formula to look in column 5 of the PR sheet and look for the words Partial, Open and Needs Ordered and return the number in column A that the words Partial, Open and Needs Ordered is in.
T5 has a 5 in it
T4 is blank
{=IFERROR(INDEX(PR!A$2:R$400,SMALL(IF(OR(INDEX(PR!$A$2:$R$400,,5)="Partial",INDEX(PR!$A$2:$R$400,,5)="Open",INDEX(PR!$A$2:$R$400,,5)="Needs Ordered"),ROW(INDEX(PR!$A$2:$R$400,,5))ROW(PR!$E$1),""),$T$5ROW($T$4)),1),"")}
This formula seems to work for just the word Partial
{=IFERROR(INDEX(PR!A$2:R$400,SMALL(IF(INDEX(PR!$A$2:$R$400,,5)="Partial",ROW(INDEX(PR!$A$2:$R$400,,5))ROW(Balance!$E$1),""),$T$5ROW($T$4)),1),"")}
T5 has a 5 in it
T4 is blank
{=IFERROR(INDEX(PR!A$2:R$400,SMALL(IF(OR(INDEX(PR!$A$2:$R$400,,5)="Partial",INDEX(PR!$A$2:$R$400,,5)="Open",INDEX(PR!$A$2:$R$400,,5)="Needs Ordered"),ROW(INDEX(PR!$A$2:$R$400,,5))ROW(PR!$E$1),""),$T$5ROW($T$4)),1),"")}
This formula seems to work for just the word Partial
{=IFERROR(INDEX(PR!A$2:R$400,SMALL(IF(INDEX(PR!$A$2:$R$400,,5)="Partial",ROW(INDEX(PR!$A$2:$R$400,,5))ROW(Balance!$E$1),""),$T$5ROW($T$4)),1),"")}