| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel - changing reference column value based on another column
Hi,
I am trying to things following way. Value @ 'Y'!F5 = 10, 'Y'!F6 = 20 Value @ 'X'!A3 = 5(meaning trying to have number 5 corresponding to 'Y'!F5) Now, I want the value of 'Y'!F5 or 'Y'!F6 at 'X'!A4, using value at 'X'!A3. so if 'X'!A3 = 5, than 'X'!A4 = 'Y'!F5 = 10 and if 'X'!A3 = 6, than 'X'!A4 = 'Y'!F6 = 20 Any Idea if this is possible using reference? or by other means? This will save lots of manual editing work for me. Please help. with Regards, - Dharmesh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS Excel - changing reference column value based on another column
You'll want to use the INDIRECT function. For example, the formula in X!A4
would be: =INDIRECT("Y!F"&X!A3) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dharmesh Patel" wrote: Hi, I am trying to things following way. Value @ 'Y'!F5 = 10, 'Y'!F6 = 20 Value @ 'X'!A3 = 5(meaning trying to have number 5 corresponding to 'Y'!F5) Now, I want the value of 'Y'!F5 or 'Y'!F6 at 'X'!A4, using value at 'X'!A3. so if 'X'!A3 = 5, than 'X'!A4 = 'Y'!F5 = 10 and if 'X'!A3 = 6, than 'X'!A4 = 'Y'!F6 = 20 Any Idea if this is possible using reference? or by other means? This will save lots of manual editing work for me. Please help. with Regards, - Dharmesh |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS Excel - changing reference column value based on another co
Thanks Luke,
it works well. Regards, - Dharmesh "Luke M" wrote: You'll want to use the INDIRECT function. For example, the formula in X!A4 would be: =INDIRECT("Y!F"&X!A3) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dharmesh Patel" wrote: Hi, I am trying to things following way. Value @ 'Y'!F5 = 10, 'Y'!F6 = 20 Value @ 'X'!A3 = 5(meaning trying to have number 5 corresponding to 'Y'!F5) Now, I want the value of 'Y'!F5 or 'Y'!F6 at 'X'!A4, using value at 'X'!A3. so if 'X'!A3 = 5, than 'X'!A4 = 'Y'!F5 = 10 and if 'X'!A3 = 6, than 'X'!A4 = 'Y'!F6 = 20 Any Idea if this is possible using reference? or by other means? This will save lots of manual editing work for me. Please help. with Regards, - Dharmesh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - changing column reference based on value of other column | Excel Discussion (Misc queries) | |||
| Excel - changing column reference based on value of other column | Excel Discussion (Misc queries) | |||
| Pasting Forumulas without changing row and/or column reference | Excel Discussion (Misc queries) | |||
| Stop cell reference in formula changing when insert column? | Excel Discussion (Misc queries) | |||
| Column Reference Based on Value | Excel Discussion (Misc queries) | |||
![Dharmesh Patel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
