Something like...

=IF(ISERROR(MATCH(A1, $B$1:$B$10, 0)),"-",A1)

.... will give you the contents of A1 if they matches a cell in B1:B10.
Otherwise, you'll get a dash.

- David


Stu wrote:
Hi! I hope someone out here can help me.
I'm trying to make my spreadsheet for work clever!
What i want is, if a cell value, in a specified range, equals any of many
specified values from a different range, then for a seperate cell to reflect
what is in the original cell.
I don't know f this is possible but any help will be appreciated.

Thanks