Pulling date from 1 ws to another while referencing 2 fields

Giganews Newsgroups
Subject: Pulling date from 1 ws to another while referencing 2 fields
Posted by:  Hakojin
Date: Thu, 18 May 2006

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

Replies