| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Value used in seperate cell as a cell location.??
Cell I7 is a drop down list of values located in cell A1 - A71. When a value
is selected in I7 I want be able to call a cell location using that value. Example: I7 = 50. I want to use a function in H7 to call the value located B'value of I7' (B50). Can't seem to figure this one out. Any help would be greatly appreciated. Thank you, Ryan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Value used in seperate cell as a cell location.??
=INDEX(B:B,I7)
-- Regards, Peo Sjoblom "ryanmhess" wrote in message ... Cell I7 is a drop down list of values located in cell A1 - A71. When a value is selected in I7 I want be able to call a cell location using that value. Example: I7 = 50. I want to use a function in H7 to call the value located B'value of I7' (B50). Can't seem to figure this one out. Any help would be greatly appreciated. Thank you, Ryan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Value used in seperate cell as a cell location.??
=indirect("B"&I7) "ryanmhess" skrev: Cell I7 is a drop down list of values located in cell A1 - A71. When a value is selected in I7 I want be able to call a cell location using that value. Example: I7 = 50. I want to use a function in H7 to call the value located B'value of I7' (B50). Can't seem to figure this one out. Any help would be greatly appreciated. Thank you, Ryan |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Value used in seperate cell as a cell location.??
Thank you Peo Sjoblom and excelent. Both answers provided worked.
Thank you! -Ryan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| seperate a cell | Excel Discussion (Misc queries) | |||
| automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| Seperate the data from the Cell | Excel Worksheet Functions | |||
| Display another cell have a cell containing its location. | Excel Worksheet Functions | |||
Linear Mode
