Get the value of a column based on the value of another column

Originally Posted by AliGW

Use INDEX MATCH:

=INDEX(C:C,MATCH(lookup_value,F:F,0))

Hi again,

Thank you for that. Is it possible to add another condition to this?

For example, How do I get the value of Column C, if Column F and Column B matches two different cell references?