Maybe you could use VLOOKUP instead. Something like:

=IF(ISNA(VLOOKUP(A1,$A$2:$A$49,1,FALSE)),"Entry not
found",VLOOKUP(A1,$A$2:$A$49,1,FALSE))

Your example would look like this (I think):

=IF(ISNA(VLOOKUP('Data Entered In'!A2,'Data
Table'!$A$2:$A$49,1,FALSE)),"Entry not found",VLOOKUP('Data Entered
In'!A2,'Data Table'!$A$2:$A$49,1,FALSE))

Regards

Trevor


"rojobrown" wrote in message
...
I have a table set up so that a user can key in one number and it flood in
the rest of her information based on a table that I have set up on another
worksheet. The formula works fine if the exact number is keyed in.
However,
if she keys in the wrong number, it still pulls information. How can I
make
it pull over only if the data is exact?
This is the formula that I have:

=LOOKUP('Data Entered In'!A2,'Data Table'!$A$2:$A$49,'Data
Table'!$A$2:$A$49)

--
Thanks a bunch!
rojobrown