For every row based on a column value, corresponding row entry

Hi There,

I have been struggling to crack a macro for the below phew, finally thought I need some support as I am unable to even do a comparison.

Let us say there are three columns as below from Row2 till Row5 in a sheet

Number Amount Param Status
74558A -1500000 CUBB Row1
74558A 1500000 CUBB Row2
74558A 2750 CUBB Row3
74558A 1375 CUBB Row4
74558A 1500000 CUBB Row5
74558A 1000000 CUBB Error

In the same Sheet, there should be corresponding rows with Param value as "LEX"

74558A -1500000 LEX Row1
74558A 1500000 LEX Row2
74558A 2750 LEX Row3
74558A 1375 LEX Row4
74558A 1500000 LEX Row5



If available then the status of the first section should be displayed in the status of the rows with LEX else, flag to be displayed "Error" in first section.

Please advise on the macro for the above.

Best Regards,
Sri