Comparing values

Closed
rosh - Jul 6, 2009 at 02:46 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 6, 2009 at 09:38 PM
Hello,
I have two columns with wth values i want to compare the two values each every value of the column 1 with the values in column two if the value is available i want it to be put on th3 third column.

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 6, 2009 at 09:38 PM
use some modification of this formula

=IF(ISNUMBER(MATCH(B2,C:C,0)),B2,"")
and copy it down

in this case the words are in column B and C
0