| 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 |
| 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)
Threaded Mode
