Hello,

In Sheet 1 Column B, I urgently need a formula to would execute the following:
Take Column A value = "Red" in sheet 1.

I need to look for value = "Red" in Sheet 2 column B and take the value in
Column C only if and only if Column A value= 2010

Sheet 2
2010 Red $10
2015 Red $15
2017 Red $16