Database check
 

I have a database of 12 different numbers, contained in the same column, on
12 successive rows.

Does anyome know if Excel is able to check whether a number entered
elsewhere on the worksheet is the same as a number in the database?

Many thanks

I would use the MATCH worksheet function to do the job:

=MATCH(A1,B1:B12,FALSE)

This would return the index of the matching item or NA if there were no
match.

--
Jim
"gunga" wrote in message
...
|I have a database of 12 different numbers, contained in the same column, on
| 12 successive rows.
|
| Does anyome know if Excel is able to check whether a number entered
| elsewhere on the worksheet is the same as a number in the database?
|
| Many thanks

Many thanks

"Jim Rech" wrote:

I would use the MATCH worksheet function to do the job:

=MATCH(A1,B1:B12,FALSE)

This would return the index of the matching item or NA if there were no
match.

--
Jim
"gunga" wrote in message
...
|I have a database of 12 different numbers, contained in the same column, on
| 12 successive rows.
|
| Does anyome know if Excel is able to check whether a number entered
| elsewhere on the worksheet is the same as a number in the database?
|
| Many thanks