Hi,
I am looking to replace the number of a cell reference with a number indicated in another cell.
Say that in A1 is "5" and in B1 is "=P8".
How do I get the 8 in B1 replaced with whatever number is placed in A1 and give the value from P#?
Thank you
Last edited by ading; 06-14-2011 at 05:20 PM.
Try this formula in B1:
=INDIRECT("P" & A1)
Another way without INDIRECT:
=INDEX(P:P, A1)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Works Great, Thank you so much.
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks