Prev: How do I get to add up only the values > than 0?
Next: If calculation
From: Mathew on 27 May 2010 15:53
Jacob: Thanks for the help, but it didn't work I get the #Ref error.

"Jacob Skaria" wrote:

> Try
> =IF(I53>0,INDIRECT("'+Agency Reallocation data'!D" & I53),"")
>
> --
> Jacob (MVP - Excel)
>
>
> "Mathew" wrote:
>
> > I have a spreadsheet with many tabs. I am trying to develop a summery sheet
> > that will 'auto fill' certain rows of data and still remain dynamic.
> >
> > What I am doing: in Column I, I have a number; I want this to be the row
> > number for finding the data in the other worksheet. I have If Statements in
> > Columns A thru E for filling the data if Column I has a number in it. If
> > Column I is empty then nothing appears. Formula is:
> >
> > =IF(I53 <> "","=+Agency Reallocation data!D&I53","")
> >
> > But, when I use this formula I get =+Agency Reallocation data!D&I53
> > Can someone help me make the formula work so that when Column has a positive
> > integer in it the formula will get the correct data. Thanks for your time!
> >
> >
From: Jacob Skaria on 27 May 2010 16:44
Check out your sheet name. Do you have a "+" in front?

--
Jacob (MVP - Excel)


"Mathew" wrote:

> Jacob: Thanks for the help, but it didn't work I get the #Ref error.
>
> "Jacob Skaria" wrote:
>
> > Try
> > =IF(I53>0,INDIRECT("'+Agency Reallocation data'!D" & I53),"")
> >
> > --
> > Jacob (MVP - Excel)
> >
> >
> > "Mathew" wrote:
> >
> > > I have a spreadsheet with many tabs. I am trying to develop a summery sheet
> > > that will 'auto fill' certain rows of data and still remain dynamic.
> > >
> > > What I am doing: in Column I, I have a number; I want this to be the row
> > > number for finding the data in the other worksheet. I have If Statements in
> > > Columns A thru E for filling the data if Column I has a number in it. If
> > > Column I is empty then nothing appears. Formula is:
> > >
> > > =IF(I53 <> "","=+Agency Reallocation data!D&I53","")
> > >
> > > But, when I use this formula I get =+Agency Reallocation data!D&I53
> > > Can someone help me make the formula work so that when Column has a positive
> > > integer in it the formula will get the correct data. Thanks for your time!
> > >
> > >
 | 
Pages: 1
Prev: How do I get to add up only the values > than 0?
Next: If calculation