Forum Discussion
Solved
Need help on how I can do this?
If Capital is Matching with Country then Status should be Correct Else Wrong.
=IF(VLOOKUP(D2,$A$2:$B$4,2,FALSE)=E2,"correct","wrong")You can try this formula for the data layout of the example.
=IF(VLOOKUP(D2,$A$2:$B$4,2,FALSE)=E2,"correct","wrong")You can try this formula for the data layout of the example.
- @QUADRUPLE PAWN You are god : ) Thank you so much
