Hi Im looking for help on how I can programme a macro to look up another workbook example

workbook 1 (original )

workbook 2 ( The one with the info)

If cells a1 , b1, c1, d1 = "yes" on workbook 2 it will put yes in workbook 1 cell g1