Jim Cone
Portland, Oregon  USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Craig" <my-place@shaw.ca>
wrote in message
Hi there, I would like to use a function that would look at a number in D1,
check to see if it exist in range A1: A8, if the number does exist then
display the D1 number in the formula cell, else display the number 1.
       If Number exist!

       A B C D E
     1 5     25
     2 9
     3 25   Formula>  25
     4 1
     5 15
     6 8
     7 3
     8 5

If Number does not exist!
       A B C D E
     1 5     11
     2 9
     3 25   Formula>  1
     4 1
     5 15
     6 8
     7 3
     8 5

Thank You for any Help!
Craig