Vlookup, Index or Match?

cwallace70,

Attached is version 3. In sheet 'summary' cell E3 and copied over and down to BV30 is this formula:

=IF(OR($B3="",$C3="",SUMIFS(INDEX(Base!$F$3:$BW$2622,0,MATCH(E$2,Base!$F$2:$BW$2,0)),Base!$B$3:$B$2622,$B3,Base!$C$3:$C$2622,$C3)=0),"",COUNTIFS(Base!$B$3:$B$2622,$B3,Base!$C$3:$C$2622,$C3)=COUNTIFS(Base!$B$3:$B$2622,$B3,Base!$C$3:$C$2622,$C3,INDEX(Base!$F$3:$BW$2622,0,MATCH(E$2,Base!$F$2:$BW$2,0)),INDEX(Base!$F$3:$BW$2622,MATCH(1,INDEX((Base!$B$3:$B$2622=$B3)*(Base!$C$3:$C$2622=$C3),),0),MATCH(E$2,Base!$F$2:$BW$2,0))))

That formula checks if there are any entries in any of the rows in sheet 'Base' in which column B and C match columns B and C from sheet 'summary'. If there is an entry, it checks if all entries for that column are identical. If they are it returns TRUE else FALSE.

The only times the formula returns TRUE are for 00099 103, 00099 104, and 00099 207 for column "1". Everything else is blank (no entries at all) or FALSE (entries found, but not all were identical). Is that what you're looking for?