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

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

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

Hi
The formula is relative not absolute, so as you copy it down the sheet
it will adjust for each successive row you wish to consider.

--
Regards

Roger Govier


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

Thanks again for your help, I ended up just combining the data from both
columns and doing a vlookup with the new column with the combined date. It
gave me what I needed.

"Roger Govier" wrote:

Hi
The formula is relative not absolute, so as you copy it down the sheet
it will adjust for each successive row you wish to consider.

--
Regards

Roger Govier


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