Coffin_joe46
New Member
- Joined
- Sep 14, 2006
- Messages
- 3
Hi,
I am trying to figure out how i could type a word into a cell, and have it lookup a section of a table.
The table will have a list of headings,
eg.
orange
apple
banana
and in the cells to the left of each heading it will have separate information about the heading e.g. colour, shape size.
What I want to do is type a heading into a cell on the sheet and have it produce all the information about that heading.
If anyone has any ideas on how they could help me it would be really appreciated! I've tried looking up the help with the lookup functions but could not figure it out.
Thanks,
Andrew
I am trying to figure out how i could type a word into a cell, and have it lookup a section of a table.
The table will have a list of headings,
eg.
orange
apple
banana
and in the cells to the left of each heading it will have separate information about the heading e.g. colour, shape size.
What I want to do is type a heading into a cell on the sheet and have it produce all the information about that heading.
If anyone has any ideas on how they could help me it would be really appreciated! I've tried looking up the help with the lookup functions but could not figure it out.
Thanks,
Andrew