populate data from one spreadsheet to another using two references

[vivekvivekverma]

Please refer the attachment. I need to populate data in sheet A from B. Values in Coloum B and C (Sheet A) are references with Coloum B and K (Sheet B)

If i need to populate actual units in coloum H (sheet A) from coloum M (sheet B) with reference to coloums B&C (sheet A) and coloums B&K (sheet B), the logic should be like

if values from B & C (Sheet A) are equal to B & K (sheet B) then H becomes equal to M.


These files i have to update each week and its a big file with 1000 rows , can anyone tell me how to code this logic.

Thanks

Vivek