Index & Match - Black Cells

[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

 

[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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[lindsey1975]

Sandy Mann

you are a pure genius......

Thanks you so much, it works a treat

 

[Sandy Mann]

Just glad that it worked for you. Thanks for the feedback

--

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk