IF Index Matching Help Pivot Table

[Harman69]

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")

 

[mart37]

=iferror(if(index(b$14:b$362,match(g115,a$14:a$362,0))<>"",index(b$14:b$362,match(g115,a$14:a$362,0)),index(c$14:c$362,match(g115,a$14:a$362,0))),"no data")