Good to see, and thanks for the response

--

Fin Analyst Wrote:
Nevermind, I figured it out. Bryan, thank you so much for the formula.
All
I had to do was add 7 to the column number, so it doesn't pick up the
row
description or total amount. So simplistic, but I didn't have time to
analyze it earlier. Here is my final formula in case anybody
encounters a
similar problem:

IF(COLUMN()<=($C$111+7),"",IF(OFFSET(I8,0,-$C111)="","",OFFSET(I8,0,-$C111)))

C111 is the number of columns I need to offset by
row 8 is the information I am pulling from

Thanks again for all the help!!

Jaclyn

"Fin Analyst" wrote:

I'm sorry, I forgot the file is on manual calculate. Once I hit F9
the
formula Bryan gave me works great. I do have one probelem though.
The
information I want actually starts in H1. There is information in
the
columns in front including a row description and a total. The cells
A1
through E1 are blank. I don't want this information in F1 and G1
showing up.
Is there any way to disinclude them from the offset formula result?
Thanks
for the help thus far!

Jaclyn

"Fin Analyst" wrote:

I tried both of these formulas suggested and the result is labeled
"volatile"
and not showing any numbers in the cells. Any other suggestions?

"John James" wrote:


The formula for, say, cell E6 is
=OFFSET(E5,0,A3)


--
John James

------------------------------------------------------------------------
John James's Profile:
http://www.excelforum.com/member.php...o&userid=32690
View this thread:
http://www.excelforum.com/showthread...hreadid=531737




--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=531737