I am struggling to figure out this formula. It has worked in the past.
this is the Formula.
=IF([Task Name]@row = "", "", IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 1}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 2}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 3}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 4}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 5}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 6}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 7}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 8}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 9}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 10}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 11}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 12}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM -Sched 13}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 14}, 0)), "") + IFERROR(INDEX({Awarded Bids FORM - Sub}, MATCH([Task Name]@row, {Awarded Bids FORM - Sched 15}, 0)), ""))
