Thread: Is there a way to use a cell value as a parm in a canned function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich Rich is offline
external usenet poster
  
Posts: 298
Default Is there a way to use a cell value as a parm in a canned function?
Using: =INDEX(A5:A748,MATCH(J2,E5:E748,0),1)

The first parm of INDEX is an array spec. Is there a way I can use the
value of cell K1 (which would contain A5) and the value of cell L1 (which
would contain A748) in the function?



Reply With QuoteReply With Quote