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.7
Overall Rating
82%
11%
4%
3%
0%
Reviews
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
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.