Creating a "valid" or a "invalid" list for accurate data input

[JinTHR]

Hello everyone, Hope everyone is doing well.

I am trying to design a spreadsheet that will be used to record information from invoices. One column in this spreadsheet will be used to record the store number that the invoice originated from. This number has to match the invoice or else the information is worthless. I am trying to come up with a way to deny the input of an incorrect number. So if the person inputting the data makes a typo, and types "1235" instead of "1234", excel prompts them with a message or just denies the input all together. I was thinking about listing all the store numbers on a separate spreadsheet and if the inputted number doesn't match that list, excel than prompts with a message or something along those lines. If anyone can help that would be fantastic! If further explanation is needed please let me know!

Thanks Everyone!
Jin

 

[Jonmo1]

You can do that with Data Validation.

If your list of valid entries is in say Sheet2!A1:A10

Then select your cell(s) that you want to restrict entry to that list
On the Data Tab, click Data Validation
Select List
And put in
=Sheet2!$A$1:$A$10
Click OK

 

[JinTHR]

Thank you so much for the extremely fast post!