Exact match - 0/FALSE looks for the first column's exact value. =VLOOKUP is an example ("Smith",A1:B100,2,FALSE).
In Excel, build an IF formula that compares the first two cells to compare two columns row by row.
The end outcome may resemble this:
=IF(EXACT(A2, B2), "Match", "")
=IF(AND(A2=B2, A2=C2), "Full match", "")
When set to 0, the match type parameter returns an exact match, whilst the other two types of values allow for an approximate match.
Learner's Ratings
4.6
Overall Rating
81%
11%
5%
3%
0%
Reviews
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.