I need a little help figuring out how i can display a cell (I28) if cell
(G28) is yes. The current formula that is working for me now is
=IF(G28="Yes",I28,"No Information to Display"). Now the problem i am having
is there is a range of cells (G28:G500) that could return a yes value but
there will be only one yes at a time in the G column and for that yes row i
would like to display that "I" cell.