Function Help

[tlaksh]

Hi,

I have two columns. Column A & Column B. I need to compare each value is column A with the whole column B and find if the value exist in column B.

Is there a function that can do that? Any help will be appreciated.


thxs

Lakshmi.

 

[ETID]

FILL THIS FORMULA DOWN IN COL. "C", TO RETURN AN X IF MATCHED BLANK IF NOT....



=IF(ISERROR(MATCH(A1,$B$1:$B$8,0)),"","X&quot


HOPE THIS HELPS

 

[ETID]

Substitute your last row in $B$8 for your last row....

 

[euskadi]

Another alternative, if you want to search all of Column B without limiting your range of searchable cells in column B is this...

In cell c1 enter this equation and fill down:
=IF(ISERROR(VLOOKUP(A1,B:B,1,FALSE)),"","X&quot