View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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