Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Graphing Database Growth Rate | Charts and Charting in Excel | |||
Auto spell check as in word | Excel Discussion (Misc queries) | |||
Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Why does spelling check close Excel when checking spanish? | Excel Discussion (Misc queries) |