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

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
20,527
Office Version
  1. 365
Platform
  1. Windows
Can you post a sample of your data?
 

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,176,486
Messages
5,903,354
Members
435,020
Latest member
rustyesimpson

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