type =select row2 in file1column1again type =select file2select row 2 of file2column2
If you do it a few times then you would become comfortable.
should I sort both column in the same order first then compare based on this ?
I copied the same colujmn from other excel to the same excel side by side now, what should I do ?
=IF(ISERROR(MATCH(B2,$A$2:$A$7,0)),"Not found","Found on row "&MATCH(B2,$A$2:$A$7,0))
Get your personalized solution.
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.
*This site is protected by reCAPTCHA and the Google
Terms of Service apply.
Please enter a first name
Please enter a last name
8+ characters (letters, numbers, and a symbol)
Take hold of your future.