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

[Pyrrhic]

I have one sheet labeled 'Main' and the other labeled 'Index'. O
'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' sheet: In cell C4, I typ
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, C
contains 11, and C9 contains 6.

If I type 'Roman' into Main's C4, then Main's C5-C9 should update t
12, 27, 42, 13, and 5, respectively.

Ultimately, I plan to have about 200 names in Index's A column, eac
with 5 values in B# through F#; if I type any one of those names int
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'
c4, in Index's A column. If found, then c5 will equal the cell one plac
to the right of the specified name on Index, c6 will equal the cell tw
places to the right of the name in Index, etc.

What are the formulas I need for Main's c4-c9, respectively? Any hel
would be appreciated

 

[Guest]

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 sheet 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.

 

[Max]

One way ..

In sheet: Main
--------------------
C4 is where you input "Greek", "Roman", etc

Put in C5:

=IF(ISNA(MATCH(TRIM($C$4),Index!$A:$A,0)),"",OFFSET(Index!$A$1,MATCH(TRIM($C
$4),Index!$A:$A,0)-1,ROW(A1)))

Copy C5 down to C9

 

[Alan Beban]

I have one sheet 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' sheet: 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.

Array enter into C5:C9 of Main:

=VLOOKUP(C4,Index!A1:F3,{2;3;4;5;6},0)

Alan Beban