From: Frustrated on 24 Feb 2010 10:33 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. From: caroline on 24 Feb 2010 11:02 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. From: Frustrated on 24 Feb 2010 11:45 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.  |