Needing Help With Excel Worksheet

[happyhappy123]

Hi, I am fairly new to Excel and was looking for help with a workbook I am creating. I want to set up a database of info that can be pulled to another sheet. I want to be able to enter one number from the database on the sheet I am working on and it will automatically pull the info from the database to my sheet. Is there a tool that makes this possible? Thanks.

[Jack7774]

A few things. Welcome to the forums. Your title of the thread is not defined enough. There are formula that can do what you are talking about and macros. Do you have an example worksheet to look at that would have an example and the results you desire, if so upload it if not you will have to give us some more details.