J
Jeff
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
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