=IF(ISERROR(MATCH(D1,A1:A8,0)),1,D1)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Craig"
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