|The =VLOOKUP() function should work for you.|
The syntax of a =VLOOKUP() is:
=VLOOKUP(ItemToFind , RangeToLookIn , ColumnToPickFrom , Matchtype)
So your Item to Find is C2
This is the part that gets tricky sometimes.
The Range to Look In should be your complete matrix,
so you start at column E
and end at Column Q, since column Q is where the data you want is located.
So your Range to look in should be E:Q
Next is the Column To Pick From, which is column Q,
so we count over, starting at column E, to column Q
which is 13 columns and this gives us our Column To PIck From
Lastly, is Match Type, 1 for Approximate, 0 for Exact
and since we want an exact match we use 0
Put the whole thing together and you get:
The only thing I would caution against is using the complete column.
It can eat up a lot of time checking 1048576 rows in Excel 2007.
Better to give the formula some limits:
See how that works.