Novice - Locating a name on another ***, then returning several specified values

anonymous_at_discussions.microsoft.com
Date: 08/02/04 

Date: Mon, 2 Aug 2004 00:51:14 -0700

Main D4 formula =VLOOKUP($C4,Index!$A1:$F24,2,FALSE)
Main E4 formula =VLOOKUP($C4,Index!$A1:$F24,3,FALSE)
Main F4 formula =VLOOKUP($C4,Index!$A1:$F24,4,FALSE)
Main G4 formula =VLOOKUP($C4,Index!$A1:$F24,5,FALSE)

Note this covers Index *** area A1 to F24 for a larger
area change F24 to reference to the bottom right of your
data.

Each cell is using Main C4 for its lookup value and then
finding this in the lookup table "Index A1:F24" but each
cell is using the appropriate lookup column, they do not
have to be in order but that is how you suggested the
outcome needed to be presented. Change the last digit in
the formula to affect which column of the lookup area is
selected. The FALSE at the end of the formula determines
whether an exact match needs to be found.

NB A lookup table will take the first matching value it
finds so beware duplicates in your Index page, also some
argue that such information needs to be
sorted "alphabetically or numerically" but I've never had
a problem.

>-----Original Message-----
>I have one *** labeled 'Main' and the other
labeled 'Index'. On
>'Index' I have 'Greek' in cell A1, 'Roman' in A2,
and 'Indian' in A3.
>In each of the 5 cells to the right of each name (i.e. B1-
F1 for Greek)
>is a distinct numerical value; no units, just single
numbers.
>
>Index's cells A1-F1: Greek 18 11 40 11 6
>Index's cells A2-F2: Roman 12 27 42 13 5
>
>Here is what I'd _like_ to do on my 'Main' ***: In
cell C4, I type
>one of the names in Index's A column - for example,
Greek. As a result,
>Main's cell C5 will contain 18, C6 becomes 11, C7 becomes
40, C8
>contains 11, and C9 contains 6.
>
>If I type 'Roman' into Main's C4, then Main's C5-C9
should update to
>12, 27, 42, 13, and 5, respectively.
>
>Ultimately, I plan to have about 200 names in Index's A
column, each
>with 5 values in B# through F#; if I type any one of
those names into
>Main's c4, then I'd like Main's c5-c9 to update to that
name's B#
>through F# values.
>
>I think what I need is a formula that looks up the name I
put in Main's
>c4, in Index's A column. If found, then c5 will equal the
cell one place
>to the right of the specified name on Index, c6 will
equal the cell two
>places to the right of the name in Index, etc.
>
>What are the formulas I need for Main's c4-c9,
respectively? Any help
>would be appreciated.
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>