Find a value on a second sheet and insert value to the left

[Dubs]

Hi all, I'm seeking some help please.
I have 2 very large sheets of data and need to copy a small amount of relevant data from one to the other. Not all data will match as the sheets have many different values.

What I need:
If a value in the claim ID column matches on both sheets then Ref_Id from Sheet 1 copies to the correct line in Sheet 2

Thanks.

 

[Nebu]

Hi:

Use a Vlookup or index match function to achieve this.

Thanks