Checking multiple columns using IFERROR

[cwelsh]

Hello,

I am using the following formula:

=IFERROR(INDEX(Roster!$F$9:$F$56,MATCH(D7,INDEX(Roster!$H$9:$AB$56,,MATCH($C$4,Roster!$H$8:$AB$8,0)),0)),0)

To check a column for data and return the matching information in column F. What if Column F is blank... How do I write this same formula to then check column G? I tried using a range $F$9:$G$56 but that didn't work.

Thank you!
Chantel

[FlameRetired]

Try

=IFERROR(INDEX(IF(Roster!$F$9:$F$56<>"",Roster!$F$9:$F$56,Roster!$G$9:$G$56),MATCH(D7,INDEX(Roster!$H$9:$AB$56,,MATCH($C$4,Roster!$H$8:$AB$8,0)),0)),0)

You may have to array enter this. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.