One way
In C2: =IF(COUNTIF(A:A,B2),B2,"")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Budask" wrote:
If cell value in B2 is shown anywhere in column A, how can I show that
cell value in C2?

I have got as far as having the following in cell C2 =IF((B2=A2),B2)
which works but only if the cell being looked for is in A2. When I try
to extend the look up to the whole of column A (say A2:A100) so that
can look in anywhere within that column, it no longer works.

Not sure if the is an "If", "lookup" or some other function - thanks.