I have a lookup/match problem that I cannot seem to get a solution
to.
I am assuming I can use a combination IF statement with a nested
VLOOKUP but it's not coming to me.

I have a table with three columns. Column A has values S01 to S08.
Column B has unique values but are associated with the values in
column A. Column C has the target values I am trying to populate in a
cell.


So the problem is that I need to match a Column A value with a column
B value to find the answer in column C. Please note that the values
in
Column A are duplicated multiple times depending on their
relationship
to the values in column B.


Any suggestions would be appreciated. Thanks.