Database check

G

gunga

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
 
J

Jim Rech

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
|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
 
Top