How can I make this so that it scans all rows on one worksheet for a match on
the other work sheet? I need it to work similar to a vlookup, but using the
combination of 2 criteria instead of 1.

This did work, but it's row specific. Thanks for your help

"Roger Govier" wrote:

Hi
Try
=IF(AND(Sheet1!B2=Sheet2!B2,Sheet1!G2=Sheet2!G2),S heet1!J2,"")

--
Regards

Roger Govier


"Hakojin" wrote in message
...
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