I've been looking at this to long, and am having a mental block. I am listing several formulas below, and am wondering if there is a way to combine the formulas into one shorter formula. So it would look through one row of data for a match, if none was found, it would move on to the next range of data, and so on. Thanks for your help. The formulas are listed below.
=INDEX('6'' & ADA Tables'!$F$175:$GH$175,MATCH('Task & Notes Master'!$A11,'6'' & ADA Tables'!$C$174:$GH$174,0)+4)
=INDEX('6'' & ADA Tables'!$F$341:$GH$341,MATCH('Task & Notes Master'!$A21,'6'' & ADA Tables'!$C$340:$GH$340,0)+4)
=INDEX('6'' & ADA Tables'!$F$673:$GH$673,MATCH('Task & Notes Master'!$A31,'6'' & ADA Tables'!$C$672:$GH$672,0)+4)
=INDEX('6'' & ADA Tables'!$F$507:$GH$507,MATCH('Task & Notes Master'!$A36,'6'' & ADA Tables'!$C$506:$GH$506,0)+4)
=INDEX('6'' & ADA Tables'!$F$839:$GH$839,MATCH('Task & Notes Master'!$A8,'6'' & ADA Tables'!$C$838:$GH$838,0)+4)
=INDEX('6'' & ADA Tables'!$F$175:$GH$175,MATCH('Task & Notes Master'!$A11,'6'' & ADA Tables'!$C$174:$GH$174,0)+4)
=INDEX('6'' & ADA Tables'!$F$341:$GH$341,MATCH('Task & Notes Master'!$A21,'6'' & ADA Tables'!$C$340:$GH$340,0)+4)
=INDEX('6'' & ADA Tables'!$F$673:$GH$673,MATCH('Task & Notes Master'!$A31,'6'' & ADA Tables'!$C$672:$GH$672,0)+4)
=INDEX('6'' & ADA Tables'!$F$507:$GH$507,MATCH('Task & Notes Master'!$A36,'6'' & ADA Tables'!$C$506:$GH$506,0)+4)
=INDEX('6'' & ADA Tables'!$F$839:$GH$839,MATCH('Task & Notes Master'!$A8,'6'' & ADA Tables'!$C$838:$GH$838,0)+4)