Ms Excel Urgent Help - Need To Return Value Of Cell Based On Parameter.

PCWorld Forums: Ms Excel Urgent Help - Need To Return Value Of Cell Based On Parameter. - PCWorld Forums

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

Ms Excel Urgent Help - Need To Return Value Of Cell Based On Parameter. I have MS Excel 2007

#1 odoc

Member

Group: Members
Posts: 28
Joined: 22-October 09
Location:Vancouver, BC

Posted 09 April 2012 - 12:54 PM

Need help urgently,

I'm trying to return the value of a cell based on another cell's value.

I.E. F7 = 200.

F8 = Sheet1!(Q214)

Essentally, I want to return from another sheet column(Q), same sheet Row(F7 + 14)

Is this possible? This is what I trie but its not working.
=CELL("contents",(Sheet1!Q(VALUE(F7))))

Please Help!!!