If yes then display information in cell
 

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.

If yes then display information in cell
 

If I understand correctly
index(I28:I500,match("yes",G28:G500,0),1)
--
caroline


"Frustrated" wrote:

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.

If yes then display information in cell
 

That worked great, thank you.

"caroline" wrote:

If I understand correctly
index(I28:I500,match("yes",G28:G500,0),1)
--
caroline


"Frustrated" wrote:

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.