Hi having trouble, pulling information through from sheet 2 into sheet 1
cells i7, j7 and k7.

Can anyone tell me what is wrong with the formulae i have typed into
these cells?
--------------:)


+-------------------------------------------------------------------+
|Filename: gcodenewsetupcopy.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4321 |
+-------------------------------------------------------------------+

--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=508678

Can't open the reference (invalid attachement).

But here's a proposal:

in e.g. A1 on sheet1 type: =Sheet2!I7
copy to B1, B2 etc

Hans

Hi, thanks for info but I need it to LOOKUP because not in set cells so
looking through a range. I can open attachment if I right click on link
and "open in another window" otherwise I too have problems accessing it.

--------------:)


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=508678

Sorry, still can't open the attachement. Can you post the formula?

Hans