But my expectation is that we should always start looking from A1 and C1 for H2, H3,H4...

A1 is a heading (as is C1) and H2 is an Employee Number .....and the only sensible match is between Employee numbers in A and H

So I do not understand what you mean by the above: nothing will ever match Reference!A1