checking for Match

[Craig]

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

 

[Jim Cone]

=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" <[email protected]>
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

 

[Craig]

Thanks.... exactly what I was looking for!
Craig