Thread: Index & Match - Black Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] lindsey1975@googlemail.com is offline
external usenet poster
  
Posts: 13
Default Index & Match - Black Cells
Hi

Can anyone tell me how to leave a cell blank when using Index and
Match

This is the formula I am using


=INDEX(Jan!$A$2:$C$215,MATCH(A11,Jan!$A$2:$A$215,0 ),2)

Any help would be most appreciated

Reply With QuoteReply With Quote