index 10 different columns, all with same match criteria

@amschock The fact that you're not getting a #NO MATCH error in those cells tells us that the match part is working.

Tell me, on Sheet B (23MasterCallOut sheet?) is there more than one row for a given employee ID? If there is, an INDEX/COLLECT may be better suited to use here, since you can specify more criteria to narrow down the row you want the data from.

It also looks like you have two different references you are matching on.

{23MasterCallOutEmployeeID}

{23MCO EID}

Friday, March 31:

=INDEX({23MasterCallOutFriday3/31}, MATCH([Employee ID]@row, {23MasterCallOutEmployeeID}, 0))

Saturday, April 1:

=INDEX({23MCO 4/1}, MATCH([Employee ID]@row, {23MasterCallOutEmployeeID}, 0))

Sunday, April 2:

=INDEX({23MasterCallOutSunday4/2}, MATCH([Employee ID]@row, {23MCO EID}, 0))

Monday, April 3:

=INDEX({23MasterCallOutMonday4/3}, MATCH([Employee ID]@row, {23MCO EID}, 0))

So if the MATCH part could match with more than one row on Sheet B, that would explain why you're getting values in one column but not values in the others despite the match being successful. Look what happens:

Sheet A was previously filled with values in each column for each Employee ID. Once I added some blanks into Sheet B, the formula pulled the blanks because it found those values first.

When I move the complete rows above the incomplete rows, the formula finds the complete rows first:

To use INDEX/COLLECT, identify the other criteria that helps you pick WHICH of the matching rows to use. For example, if you always want the newest rows, you can use the MAX function within the COLLECT portion to indicate you want the row for that employee ID with the newest created date or entry date.

YES!!! Fantastic! What other criteria did you end up using to pick the correct matching row?