I have two worksheets with identical column headings. Column J in sheet 1 is
blank, Column J in sheet 2 has a date. I need the formula to pull the date
from sheet 2 when B and G have the same data on both sheets.

Column B Column G Column J
Client ID Customer Branch Date
2435 Eagle Rock