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


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=385815

Hi Andrewm,

Try,

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

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=385815

TYpo

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

--
HTH

Bob Phillips

"Krishnakumar"
wrote in message
news:Krishnakumar.1rwaaa_1120899907.4138@excelforu m-nospam.com...

Hi Andrewm,

Try,


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

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile:
http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=385815