index match with blank entries

[andrewm]

Hi

I have a formula - =index(B1:B10,(match(C1,A1:A10,0)))

however when there is a blank in row B it returns a 0, how can I change
it to enter a blank instead?

many thanks

andrewm

 

[Krishnakumar]

Hi Andrewm,

Try,

=if(isblank(index(B1:B10,(match(C1,A1:A10,0))),"",index(B1:B10,(match(C1,A1:A10,0)))

HT

 

[Bob Phillips]

TYpo

=IF(ISBLANK(INDEX(B1:B10,(MATCH(C1,A1:A10,0)))),"",INDEX(B1:B10,(MATCH(C1,A1
:A10,0))))

--
HTH

Bob Phillips

"Krishnakumar" <[email protected]>
wrote in message
news:[email protected]...