Search function

[SilenTScopE]

Hey,

I want to search for a value (values are in column A) in an array (column B). If it is found, i want that value to be pasted in column C. If it is not found, I don't want anything to happen. I tried using the search function but that doesn't work. Is there another way to make this work?

Thanks!

[NBVC]

Try

=If(isnumber(match(A1,B:B,0)),A1,"")

copied down.

[SilenTScopE]

Thanks! Works fine.