If yes then display information in cell

[Frustrated]

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.

 

[caroline]

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

 

[Frustrated]

That worked great, thank you.

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