How to match against two columns in different sheets

[Pope_003]

Hello,

I'm hoping someone can please assist me with the attached spreadsheet example.

Excel Query.xlsx

Essentially, I would like to be able to match all the "Name"s in column B of Sheet 1, against the names in Column B of sheet 2.

This would then result in the "Colour" being correlated from column D in sheet 2, with the "Colour" column in Sheet 1 against the appropriate name.

Any help is greatly appreciated.

Thank you,

David

[samba_ravi]

Try
=VLOOKUP(B2,'Sheet 2'!B:D,3,0)
or
=INDEX('Sheet 2'!D:D,MATCH('Sheet 1'!B2,'Sheet 2'!B:B,0))
and copy towards down

[Pope_003]

Perfect, the second option worked well. Thank you!