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