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
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

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))
 

Forum statistics

Threads
1,140,937
Messages
5,703,256
Members
421,289
Latest member
fbohlandt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top