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