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!!!
Are you looking for in F8
= INDIRECT("Sheet1!Q"&(F7 +14))
?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks alot!! Thats exactly what I was looking for!
Cheers!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks