View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
loba loba is offline
external usenet poster
 
Posts: 1
Default index function without row & col (comma only)

Can someone explain what it does - index(array,)

e.g.
INDEX(($A$2:$A$100=L1)*($B$2:$B$100=M1),)

Thanks.
--
Barry