lookup?

[joe.c]

Hi,

I'm new to excel and at the moment haven't really got many ideas on how
to do anything unless its very basic..

I wondered if anyone has a simple or otherwise solution to this..

On one page i have a list of words and to the left of it a column
numbering them

1. first item
2. something else

etc.

on a different page i want to be able to type a number refering to the
item next to it on the other page

so i would have something like

item number | item name
45 | (automatically fills in name of item from list on
second page)

I am about to give up but thought i'd try and piece together a question
on here first

thanks

joe



------------------------------------------------




------------------------------------------------

 

[Dan E]

Joe,

You have a number of options here.
Setup:
On a sheet named test in A1:A26 I put the index #'s
On sheet1 in A2 i put the desired index number
The simplest (only worksif your items are numbered
consecutively and starting at 1 is:
=INDEX(Test!B1:B26,A2)
Which just looks up the 22nd item in the list (thats
why it only works if your items are numbered
consecutively.

A second option:
=LOOKUP(A2,Test!A1:A26,Test!B1:B26)
looks up A2 (index #) in A1:A26 and returns a value
from B1:B26 the same number of rows down.

A third option
=VLOOKUP(A2,Test!A1:B26,2,FALSE)
looks up A2 (index #) in A1:A26 and returns a value
from the second column over in A1:B26 so the value
next to it from column B

Dan E