Hi all, Needing help I am not a super excel user but just wondering if someone could help me with a formula to extract data from a pivot table. I currently have a formula that works by matching and picking up data but i am trying to pick up data from 2 cells. so i am needing to get my formula to take data from B$14:B$362 which it dose currently but if the cell is blank match and take data from C$14:C$362. Is this
possible.
=IFERROR(IF(INDEX(B$14:B$362,MATCH(G115,A$14:A$362,0))=0,"OFF",IF(INDEX(B$14:B$362,MATCH(G115,A$14:A$362,0))/INDEX(I$14:I$292,MATCH(G115,G$14:G$292,0))<0.75,"Underperforming","Operating")),"NO DATA")
possible.
=IFERROR(IF(INDEX(B$14:B$362,MATCH(G115,A$14:A$362,0))=0,"OFF",IF(INDEX(B$14:B$362,MATCH(G115,A$14:A$362,0))/INDEX(I$14:I$292,MATCH(G115,G$14:G$292,0))<0.75,"Underperforming","Operating")),"NO DATA")
