Search with multiple criteria and display blank cell also

[Villalobos]

Hello,

I would need you advice regarding blank cell displaying.
In my sample file I search the target value based on 2 criterias, it is working fine but if the formula doesn't find anything then turn to 0. i would like that if the formula doesn't find anything then turn to blank cell instead of 0.

The original file has more 1000 rows.



Thank you in advance your advice!

 

[Deepak]

Just remove the N/A from "N/A".

=IFERROR(INDEX(MAV!$M$17:$M$1033,MATCH(H17 & K17,MAV!$H$17:$H$1033 & MAV!$K$17:$K$1033,0)),"")

 

[Villalobos]

Hello Deepak,

On my PC the formula still represent 0 value instead of blank cell.

 

[Deepak]

It's formatting issue so far. Pls wait

 

[Deepak]

Formula remain same just did conditional formatting.

& another req formula : =AVERAGEIF(O17:O18,">0",O17:O18)

 

[Villalobos]

It is almost good but if the formula find 0 value then it should display.

 

[Deepak]

Check it

 

[Villalobos]

we are very close but if I write 100 into sheet MAV!M17 then the formula give back 0 on sheet DDD!O17

 

[Deepak]

by Bad...

check this..

 

[Villalobos]

Thank you Deepak, you solved my problem and were very helpful with me!