Well thanks alot for the solution
but I have one more question that while using the formula specified by you
that is:

=IF(VLOOKUP(A2, 'Cutting or Slitting'!A:Z, 14, 0)=0,0,VLOOKUP(A2,
'Cutting or Slitting'!A:Z, 10, 0))

I was getting a circular reference but when I changed A2 to 1 then its
working fine
Do u suspect any problem with that if so please let me know.

Another thing if there is no problem suspected with the changed formula that
I am usign then how can I auto fill the formula in 1000 Rows with the 1
increasing in steps of 1 till 999.

Will using this formula mean that the formula in A2 row of the RG sheet will
always refer to the data corresponding to S.No.1 in sheet 'Cutting or
Slitting' even if I resort 'Cutting or Slitting'.

Does the S.no column for VLOOKUP need to be sorted in ascending order or
they can work without the sorting