Prev: Formatting issue
Next: Create a formula in a worksheet that links two other worksheets
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.
 | 
Pages: 1
Prev: Formatting issue
Next: Create a formula in a worksheet that links two other worksheets