INDEX and MATCH

[AndyMax]

Hi guys

I use formula below.

=IFERROR(INDEX('km'!$B$2:$B$4521;MATCH(D7;'km'!$A$2:$A$4521;0));"No")

If error the formula return NO. The problem is when I start the file cell D7 is blank and the formula return No. If D7 is blank I want the formula to return nothing or blank instead of NO.

Someone who can help me?

Thx in advance

Br

Andy

 

[azumi]

Maybe

=IFERROR(IF(D7="";"";INDEX(km!$B$2:$B$4521;MATCH(D7;km!$A$2:$A$4521;0)));"No")

 

[AndyMax]

thx for your help