Datbase 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

Yes.

If the number is always going to be entered in a specific location, you
could use conditional formatting. If A1:A12 contains your "database" and D12
is where the new entry is going to be, the condition would be:

=OR(D12=$A$1:$A$12)

--

Vasant



"gunga" <[email protected]> wrote in message
news:[email protected]...
> 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
>

Thanks for your help. I've found that =MATCH offers an even better solution.

"Vasant Nanavati" wrote:

> Yes.
>
> If the number is always going to be entered in a specific location, you
> could use conditional formatting. If A1:A12 contains your "database" and D12
> is where the new entry is going to be, the condition would be:
>
> =OR(D12=$A$1:$A$12)
>
> --
>
> Vasant
>
>
>
> "gunga" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>