Here's my situation- I've got a VLOOKUP set up in column D which references the (row based) value in Column A as the lookup_value, where Columns B and C are the table_array (returning C exactly) e.g. in D1:
=vlookup(A1,B:C,2,false). This works as it should.
Column C contains the text...