Vlookup data from a merged cell

Occasional Visitor

I have source data with merged cell. Whenever I call the data through Vlookup, shows the value of first cell only, rest cell shows only 0. What will be the solution. Condition is it should be done by Vlookup only, without VBA.

0 Replies