HIEPIC.COM : 1984-2024
January 16, 2019
[XLS]Check if one column value exists in another column using MATCH
Default
=NOT(ISERROR(MATCH(A2,$B$2:$B$1001,0)))
1
=
NOT
(
ISERROR
(
MATCH
(
A2
,
$
B
$
2
:
$
B
$
1001
,
0
)
)
)
Author Details
epic
Contributer and Author
Enterprise Communications Engineer
Hi Epic
theelau@gmail.com
415-000-0000
testest test
0
0
votes
Article Rating
Subscribe
Login
Notify of
new follow-up comments
new replies to my comments
Label
{}
[+]
Name*
Email*
Website
Δ
Label
{}
[+]
Name*
Email*
Website
Δ
0
Comments
Oldest
Newest
Most Voted
Inline Feedbacks
View all comments
wpDiscuz
Insert