Comparing And Retrieving Value With Blank Cells

[mmarhala1978]

[TABLE="width: 100%"]
<tbody>[TR]
[TD]Hi, All the expert people out there.
I am stuck in a problem and have tried lots of option but no success.I have two sheets in one worksheet and I am comparing 2 columns to retrieve the value from one into another. screenshot attached
The problem is that the sheet I am retrieving the value from have 2 blank rows and have to skip them.
I am not able to skip and retrieved the right value when ever a blank row is there.
please advise

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Welcome to the MrExcel board!

You cannot show images that are stored on your own computer. In any case, helpers here cannot copy sample data from images to test with.
My signature block below has a link to methods of showing small sample data in your post and it can be copied from there to test with.