Compare two columns in two worksheets and return data from another column

[SRA122]

I have two worksheets and I am wanting to compare two columns (one from each worksheet). If there is a match, I want to pull the data from the matching row
but from a different column.

Example:

1st worksheet

A B C
xyz 123
abc 456
dfg 788


2nd worksheet

A B C
123 ddd apple
999 ccc orange
888 eee peach
456 xxx plum
777 yyyy pear
788 bbb banana

Result I am looking for in 1st worksheet Column C:

A B C
xyz 123 apple
abc 456 plum
dfg 788 banana

Thanks!

 

[KyleUK]

In C1 on Sheet1

=VLOOKUP($B1,Sheet2!$A$1:$C$6,3,0)

 

[MarcelBeug]

Assuming headers in row 1, enter in C2 and copy down:

=VLOOKUP(B2,Sheet2!$A$2:$C$7,3,0)

 

[MickG]

??