Find the value in a row of a matching column
Closed
shiny
-
Jan 27, 2012 at 01:37 PM
tibouuh Posts 2686 Registration date Sunday June 29, 2008 Status Contributor Last seen February 9, 2017 - Jun 26, 2012 at 08:44 AM
tibouuh Posts 2686 Registration date Sunday June 29, 2008 Status Contributor Last seen February 9, 2017 - Jun 26, 2012 at 08:44 AM
Related:
- Find the value in a row of a matching column
- Saints row 2 cheats - Guide
- How to delete a row in a table in word - Guide
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- We can’t give you access to this account or help with your request until we receive an accepted form of id that matches the information listed on the account. learn more about the types of id we accept in the help center: ✓ - Facebook Forum
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
1 response
tibouuh
Posts
2686
Registration date
Sunday June 29, 2008
Status
Contributor
Last seen
February 9, 2017
Jun 26, 2012 at 08:44 AM
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
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