This formula should do the trick:

Will compare the first and last names and return true or false.Code:=B2 & C2 =VLOOKUP(A2,Sheet1!$A$2:$C$500,2,FALSE) & VLOOKUP(A2,Sheet1!$A$2:$C$500,3,FALSE)

or

Does B2 & C2 equal column B & C on whichever row the the NPI number appears between rows 2 & 500.

Edit: Will return an #N/A error if the NPI doesn't appear on both sheets.

## Like this thread? Share it with others