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

Index & Match - Black Cells
 

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

Index & Match - Black Cells
 

Sandy Mann

you are a pure genius......

Thanks you so much, it works a treat :)

Index & Match - Black Cells
 

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


with @tiscali.co.uk


wrote in message
oups.com...
Sandy Mann

you are a pure genius......

Thanks you so much, it works a treat :)