Find the value in a row of a matching column
Closed
shiny
-
Jan 27, 2012 at 01:37 PM
tibouuh
tibouuh
- Posts
- 2683
- Registration date
- Sunday June 29, 2008
- Status
- Contributor
- Last seen
- February 9, 2017
Related:
- Find the value in a row of a matching column
- Formula that searches in a row for a cell/column that contains ✓ - Forum - Excel
- Converting Rows of data into Columns ✓ - Forum - Excel
- Macro to highlight a row if cells match value ✓ - Forum - Excel
- Paste data below the last used row - Guide
- Excel create unique id for each row ✓ - Forum - Excel
1 reply
tibouuh
Jun 26, 2012 at 08:44 AM
- 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
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