Looking up from a table

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
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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
BCDEF
17philorange
26daveapple
34barrybanana
4
5
6
7lookup
87philorange
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))
 

Watch MrExcel Video

Forum statistics

Threads
1,113,846
Messages
5,544,630
Members
410,626
Latest member
rkmadasu
Top