Hello,

I have a large Table of various data. Column C is a text string, and Column F is a number.

How do I get the value of Column C, if Column F matches a particular cell reference/number.

I cannot use VLOOKUP as the columns are not to the left.

Thank you.