Formula help

wendy.ward_123

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

AravindGP

Hi @wendy.ward_123

What is the issue? What result are you getting and what should the result be? From the looks of it, you've tasks listed and are trying to get a value from an identical column across 15 different sheets and I assume your Task Name could appear in any one of these 15 sheets to pull the value.