Search for value and write x in cell

Hi all,

Got a question on a formula. I've setup and attached an example on my question below. Would awesome if you could help me out on this one!

When the value on row 2 column D is registered in one of the cells on page1 in column C then write down an "x" in F2, this continues for all rows. If the value is not found in the column on page 1 column C then leave it empty….

please help.xlsx

Greetings,

Ben

you could use an IF with a match
but i dont understand the

this continues for all rows

.

otherwise =IF(ISERROR(MATCH(D2,'Page 1'!$C$2:$C$16,0)),"","X")

Aha....sorry for that....I mean search the whole column for that value....

WHen I use a clean new excel file or the example file that I provided it works! Thanks for that....the original though doesn't.....But I will find out! Thanks

strange maybe theres a format issue or hidden character