Index & Match - Black Cells

L

lindsey1975

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
 
S

Sandy Mann

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,Jan!$A$2:$A$215,0),2))

--
HTH

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

[email protected]
[email protected] with @tiscali.co.uk
 
Top