How Do I Determine If A Value In One Column Exists In Another Column? - Excel
How Do I Determine If A Value In One Column Exists In Another Column? - Excel
If you want to know that the value of first column exist in second column in excel so
So place at first column which data you want to check and place in second column which will you compare first column data.
Now paste this code in 3rd colum....
=IF(ISNA(VLOOKUP(A1,$B$1:$B$600,1,FALSE)),"","Yes")
Simply paste this code and if exist so it will return yes in front of that column....
If you want to know that the value of first column exist in second column in excel so
So place at first column which data you want to check and place in second column which will you compare first column data.
Now paste this code in 3rd colum....
=IF(ISNA(VLOOKUP(A1,$B$1:$B$600,1,FALSE)),"","Yes")
Simply paste this code and if exist so it will return yes in front of that column....
Comments
Post a Comment