Setting up a database...sort of...

[Fredilev]

I have a series of products that will be tested. There are 3 questions regarding taste and texture attributes of those products that are asked when they are tested. There have been 1500 products tested in the past year but every time a product is tested, someone manually comes up with the 3 questions to ask.

So -- If a pizza is tested, they may ask questions about the firmness of the crust, the sweetness of the sauce and the amount of cheese. If they test soup, they may ask about the level of salt, the thickness of the texture and the amount of vegetables.

It seems that there must be a way set up a spreadsheet or a database where you can have a list of products followed by the three questions that will be asked. You'd also have a list of questions.

The question I have is how do you link those? It would be nice if you could have the name of the question and have it take you to the actual question when you click on it.

Any thoughts?

 

[Trevor G]

On a sheet create your questions Like this sample

Excel Workbook
	A	B	C	D
1	Fruit	Apples	Cabbage	Bread
2	Other Stuff	Oranges	Lettuce	Meat
3	Vegetables	Lemons	Carrots	Chocolate
4		Grapes	Beets
5			Brussels Sprouts
6			Celery
Lists

Excel Workbook
	B	C
1	Category	Item
2	Vegetables	Lettuce
3	Other Stuff	Chocolate
4	Other Stuff
5
6
7
8
9
10
11
12
13
14
15
Excel 2007

#VALUE!

Excel 2007

​