jamiegreen
New Member
- Joined
- Sep 3, 2007
- Messages
- 9
I am trying to create an Excel database where I input a number and it finds the information that I am looking for.
For example, I have a list of 20 different companies that each have various supply numbers for properties ranging over a period of around 400,000 numbers spread out over between them. I want to be able to input a specific supply number on the database and it provides me with the relevant area, contact number for the company, and address etc.
So if the number that I input falls between 3000 and 4000, the details for one company appear. However if I input another number between 4000 and 5000 then a different company name appears, and so on.......
I am struggling with the formula, is this possible?
For example, I have a list of 20 different companies that each have various supply numbers for properties ranging over a period of around 400,000 numbers spread out over between them. I want to be able to input a specific supply number on the database and it provides me with the relevant area, contact number for the company, and address etc.
So if the number that I input falls between 3000 and 4000, the details for one company appear. However if I input another number between 4000 and 5000 then a different company name appears, and so on.......
I am struggling with the formula, is this possible?