| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
This should be simple
I just need to reference a cell in another worksheet with a variable. Like let's say A1=1 A2=2 A3=3 B1=red B2=white B3=blue Here's where I'm having trouble. I want C1 to equal B(a2) or in effect white But I can't figure out the formula. From what I learned I think it should be C1="b"& Other Sheet.indirect(a2) but it's not working for me. Please help, this is frustrating as all get out, -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
This should be simple
One way is:
=INDEX(B:B,A2) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "famdamly" wrote in message ... I just need to reference a cell in another worksheet with a variable. Like let's say A1=1 A2=2 A3=3 B1=red B2=white B3=blue Here's where I'm having trouble. I want C1 to equal B(a2) or in effect white But I can't figure out the formula. From what I learned I think it should be C1="b"& Other Sheet.indirect(a2) but it's not working for me. Please help, this is frustrating as all get out, -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500003 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
This should be simple
Hi!
Try this: =INDIRECT("B"&A2) Biff "famdamly" wrote in message ... I just need to reference a cell in another worksheet with a variable. Like let's say A1=1 A2=2 A3=3 B1=red B2=white B3=blue Here's where I'm having trouble. I want C1 to equal B(a2) or in effect white But I can't figure out the formula. From what I learned I think it should be C1="b"& Other Sheet.indirect(a2) but it's not working for me. Please help, this is frustrating as all get out, -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500003 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
This should be simple
You mean this? =INDIRECT("B"&Sheet2!A2) Regards JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=500003 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
This should be simple
Sorry, didn't realize you were talking about different WS's.
The example I posted was where all columns and the formula are on the same sheet. =INDEX(B:B,A2) Actual formula depends on: where is the formula, where is the column to lookup, where is the column to reference. Could be any of these: Formula on Sheet1, both columns on Sheet2, =INDEX(Sheet2!B:B,Sheet2!A2) Formula on Sheet1, reference column on Sheet1, lookup column on Sheet2, =INDEX(Sheet2!B:B,A2) Formula on Sheet1, reference column on Sheet2, lookup column on Sheet1, =INDEX(B:B,Sheet2!A2) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "RagDyer" wrote in message ... One way is: =INDEX(B:B,A2) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "famdamly" wrote in message ... I just need to reference a cell in another worksheet with a variable. Like let's say A1=1 A2=2 A3=3 B1=red B2=white B3=blue Here's where I'm having trouble. I want C1 to equal B(a2) or in effect white But I can't figure out the formula. From what I learned I think it should be C1="b"& Other Sheet.indirect(a2) but it's not working for me. Please help, this is frustrating as all get out, -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500003 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
This should be simple
Thank you ver much for your help. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500003 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
This should be simple
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "famdamly" wrote in message ... Thank you ver much for your help. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple, but not for me...help | Excel Worksheet Functions | |||
| Simple Formula (I thought) | Excel Worksheet Functions | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Help with what should be a simple formula | Excel Worksheet Functions | |||
| Simple But Stumped | Excel Discussion (Misc queries) | |||
Linear Mode
