I want to be able to take the value of A2, and lookup in a range of cells on
another sheet, and if it finds the value of a2 in that range, then display
"open". If it doesn't find the value of A2 in the range, I want it to
display "closed". Is it possible to make this happen?