If you mean a blank looking cell when the formula fails then try:

=IF(ISNA(INDEX(Jan!$A$2:$C$215,MATCH(A11,Jan!$A$2: $A$215,0),2)),"",INDEX(Jan!$A$2:$C$215,MATCH(A11,J an!$A$2:$A$215,0),2))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


wrote in message
ups.com...
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