Using a Cell Value in another Cell Address
Greetings All, This may be a basic question, but it's giving me trouble. I'm trying to set up a worksheet where by inputing a value in a cell, it changes the value reference in another cell to a new address.....(confused yet?) Ex: in A1, the person would input "24" then, the value in B2 would equal the value in C24 if they put in "13" into A1, the value in B2 would equal the value in C13 Does that make sense? Also, can I use a simple equation in it....like subtraction Ex: in A1, the person would input "52" then, the value in B2 would equal the value in C12, which is 52-40 in A1 the person would input "68" then the value in B2 would equal the value in C28, which is 68-40 Thanks for your help everyone!!! Sam -- samccaskill ------------------------------------------------------------------------ samccaskill's Profile: http://www.excelforum.com/member.php...o&userid=27805 View this thread: http://www.excelforum.com/showthread...hreadid=473120 |
In B2:
=INDIRECT("C"&A1) -- Regards, Dave "samccaskill" wrote: Greetings All, This may be a basic question, but it's giving me trouble. I'm trying to set up a worksheet where by inputing a value in a cell, it changes the value reference in another cell to a new address.....(confused yet?) Ex: in A1, the person would input "24" then, the value in B2 would equal the value in C24 if they put in "13" into A1, the value in B2 would equal the value in C13 Does that make sense? Also, can I use a simple equation in it....like subtraction Ex: in A1, the person would input "52" then, the value in B2 would equal the value in C12, which is 52-40 in A1 the person would input "68" then the value in B2 would equal the value in C28, which is 68-40 Thanks for your help everyone!!! Sam -- samccaskill ------------------------------------------------------------------------ samccaskill's Profile: http://www.excelforum.com/member.php...o&userid=27805 View this thread: http://www.excelforum.com/showthread...hreadid=473120 |
First question:
In B2 enter: =INDEX(C:C,A1) Second question: In B2 enter: =INDEX(C:C,A1-40) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "samccaskill" wrote in message ... Greetings All, This may be a basic question, but it's giving me trouble. I'm trying to set up a worksheet where by inputing a value in a cell, it changes the value reference in another cell to a new address.....(confused yet?) Ex: in A1, the person would input "24" then, the value in B2 would equal the value in C24 if they put in "13" into A1, the value in B2 would equal the value in C13 Does that make sense? Also, can I use a simple equation in it....like subtraction Ex: in A1, the person would input "52" then, the value in B2 would equal the value in C12, which is 52-40 in A1 the person would input "68" then the value in B2 would equal the value in C28, which is 68-40 Thanks for your help everyone!!! Sam -- samccaskill ------------------------------------------------------------------------ samccaskill's Profile: http://www.excelforum.com/member.php...o&userid=27805 View this thread: http://www.excelforum.com/showthread...hreadid=473120 |
All times are GMT +1. The time now is 02:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com