Previous Topic Next Topic

Find the value in a row of a matching column

Closed
shiny - Jan 27, 2012 at 01:37 PM
tibouuh
Posts
2683
Registration date
Sunday June 29, 2008
Status
Contributor
Last seen
February 9, 2017
 - Jun 26, 2012 at 08:44 AM
Hello,
If you are able to help, I would be greatly appreciative!

I would like to find a formula that would look up the value in a cell, find the matching columnvalue and return the value on the the corresponding row of the value looked up.
For example...I would like to look up Schusser's class year in the matching column and return the value 10, which is in the Schusser's row.

Name Class '12 '11 '10 '09
Herold ''11 6 0 0 0
Crutcher ''12 6 0 0 0
Schusser ''10 8 10 30 0
Wainwrig ''11 3 0 0 0
Finney '09 22 100 100 0
Starr ''12 6 0 0 0

Thank you for your time and effort in helping me!


1 reply

Answer 1 / 1
tibouuh
Posts
2683
Registration date
Sunday June 29, 2008
Status
Contributor
Last seen
February 9, 2017
Jun 26, 2012 at 08:44 AM
Hello,

you should try this formula :
=vlookup("Schusser",your table,2)

I don't have the English version of Excel installed on my computer, so I don't remember if the symbol used is "," or ";" like in the French version.
I let you replace your table by the correct table which contains the 6 lines and the 6 rows apparently.
the number "2" is to get the value of the second row of your table (for year 2012 apparently).

if you need more explanations, ask me! ^^
bye
0