Hi Experts,
How can I get the results of vlookup where there are two corrsponding data
in other sheet. One is blank and the other is non blank. I want to get the
results of non blank cell and ignore the blank one.

Thanks