Comparing lists (2003)

[Buddy]

How can I compare the telephone codes - What I need to do is compare supplier 1 codes against supplier 2 in one column then compare supplier 1 with supplier 3 and return the results in another column ??

[HansV]

Can you please explain in detail what you want to do (for example, which columns must be compared, do you only want to compare values in the same row or across rows, etc. - be as specific as possible) and what the result should look like?

[Buddy]

I need to compare the telephone codes in column B with those in column E, then column B codes with column H codes.
In column J I would like to see the results from column B versus E - so if the code in cell B3 (1876) appears anywhere in column E then cell J1 will return the code itself (1876).
When comparing column B versus column H the results should appear in column K.

[HansV]

If I understand you correctly, the following should do what you ask: in cell J3, enter this formula:

=IF(B3="","",IF(COUNTIF($E$3:$E$33,B3),B3,""))

and in cell K3, enter this formula:

=IF(B3="","",IF(COUNTIF($H$3:$H$33,B3),B3,""))

Select J3:K3 and fill down to row 33.

[Buddy]

Thanks Hans worked perfectly