Skip Blanks and lookup the values

[fareedexcel]

Hi Excel Users,

Please help in getting the value by skipping the empty cells. I have attached a sample sheet for your reference.

 

[pecoflyer]

Try =INDEX($D$5:$D$9,MATCH(1,($B$5:$B$9=$F$5)*($C$5:$C$9=$G$5)*($D$5:$D$9<>"")))
committed as an array formula with Ctrl+Shift+Enter

 

[fareedexcel]

Thanks. This is working fine.

 

[rahulshewale1]

hi @fareedexcel,

try this
H5=MAXIFS($D$4:$D$9,$B$4:$B$9,F5)

 

[fareedexcel]

What is the formula adjustment if i have a blank space in the empty cell. Now the formula is giving the value is 0 not giving me the actual value.