How to cross check data in different Excel worksheets-CodePudding

How can I make sure that the postcode corresponding to a name in worksheet 1 matches the address for the same name in worksheet 2.

For example, I would need a column with a vlookup or index/match formula that would check Alice's postcode from worksheet 1 against Alices postcode in worksheet 2 and return true for a match of the postcode or false if the postcode is different.

Worksheet 1

Name   Address  DOB  Post code
Alice  Berlin   1980 W2
Bob    London   1979 EC1

Worksheet 2

Name  Address Post Code DOB
Alice London  EC        1979
Alice Berlin  W2        1980

I don't think a vlookup is ideal because of performance and column positioning.

CodePudding user response：

Use a IF formula

For example in Sheet2 : =IF(B5=Sheet1!B5,"True"'"False")