Looking up from a table

[Coffin_joe46]

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

 

[Domenic]

Can you post a sample of your data?

 

[barry houdini]

and in the cells to the left of each heading.....

Are you sure you mean to the left? If you do and you also want to reproduce the data to the left try

Book1
	B	C	D	E	F
1		7	phil	orange
2		6	dave	apple
3		4	barry	banana
4
5
6
7				lookup
8		7	phil	orange
9
Sheet2

Formula in D8 which can be copied across (to the left) and down..

=INDEX(D$1:D$3,MATCH($E8,$E$1:$E$3,0))