Lookups in Excel - How?

Feek · 09-11-2008, 15:11

I'm doing some stuff in Excel which I think needs a lookup table of some sort.

Basically I have a number of items and an associated number. I need to select the item using a drop-down and then have the associated number appear in a cell next to the item.

How do I do this? I'm sure it's something simple.

Ta.

09-11-2008, 15:11	#1
Feek ex SAS Join Date: Jun 2006 Location: JO01ou Posts: 10,062	Lookups in Excel - How? I'm doing some stuff in Excel which I think needs a lookup table of some sort. Basically I have a number of items and an associated number. I need to select the item using a drop-down and then have the associated number appear in a cell next to the item. How do I do this? I'm sure it's something simple. Ta. __________________