VBA code to return value in specific Column based on criteria

[SamCha]

Hi all,

Please can you help me with a code for the below:

[TABLE]
[TR]
[TD]=IF(H5>0,IF('Sheet 2'!M2>0,'Sheet 2'!M2, Sheet2'!L2),"")[/TD]
[/TR]
[/TABLE]

The return value is in Sheet 1 in Column K. If there is a value in Sheet 1 in Column H5 (the column size varies staring from Row 5) , then return the result from Sheet 2 from Column M (data starts from Row 2) or else return column L. The cell is formatted as text as there are leading zeros (number of zeros in each number is not consistent), so cant convert it to general or apply formula.

Thanks in advance

 

[maabadi]

Replace M2 with M2*1 and So on.