Not real clear what you want. Here's my best guess.

Testing if *any* number in the range A1:A10 also appears in the range
J1:J20:

=INDEX(A1:A10,MATCH(TRUE,INDEX(ISNUMBER(MATCH(A1:A 10,J1:J20,0)),,1),0))

A result of #N/A means no numbers in A1:A10 appear in J1:J20. If more than
one number from A1:A10 appears in J1:J20 the formula returns the *first*
number that meets the condition.

--
Biff
Microsoft Excel MVP


"Stu" wrote in message
...
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