software

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,quot;quot;)

--
Regards

Roger Govierquot;Hakojinquot; gt; wrote in message
...
gt;I have two worksheets with identical column headings. Column J in sheet
gt;1 is
gt; blank, Column J in sheet 2 has a date. I need the formula to pull the
gt; date
gt; from sheet 2 when B and G have the same data on both sheets.
gt;
gt; Column B Column G Column J
gt; Client ID Customer Branch Date
gt; 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

quot;Roger Govierquot; wrote:

gt; Hi
gt; Try
gt; =IF(AND(Sheet1!B2=Sheet2!B2,Sheet1!G2=Sheet2!G2),S heet1!J2,quot;quot;)
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Hakojinquot; gt; wrote in message
gt; ...
gt; gt;I have two worksheets with identical column headings. Column J in sheet
gt; gt;1 is
gt; gt; blank, Column J in sheet 2 has a date. I need the formula to pull the
gt; gt; date
gt; gt; from sheet 2 when B and G have the same data on both sheets.
gt; gt;
gt; gt; Column B Column G Column J
gt; gt; Client ID Customer Branch Date
gt; gt; 2435 Eagle Rock
gt;
gt;
gt;

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 Govierquot;Hakojinquot; gt; wrote in message
news
gt; How can I make this so that it scans all rows on one worksheet for a
gt; match on
gt; the other work sheet? I need it to work similar to a vlookup, but
gt; using the
gt; combination of 2 criteria instead of 1.
gt;
gt; This did work, but it's row specific. Thanks for your help
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi
gt;gt; Try
gt;gt; =IF(AND(Sheet1!B2=Sheet2!B2,Sheet1!G2=Sheet2!G2),S heet1!J2,quot;quot;)
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Hakojinquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have two worksheets with identical column headings. Column J in
gt;gt; gt;sheet
gt;gt; gt;1 is
gt;gt; gt; blank, Column J in sheet 2 has a date. I need the formula to pull
gt;gt; gt; the
gt;gt; gt; date
gt;gt; gt; from sheet 2 when B and G have the same data on both sheets.
gt;gt; gt;
gt;gt; gt; Column B Column G Column J
gt;gt; gt; Client ID Customer Branch Date
gt;gt; gt; 2435 Eagle Rock
gt;gt;
gt;gt;
gt;gt;
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.

quot;Roger Govierquot; wrote:

gt; Hi
gt; The formula is relative not absolute, so as you copy it down the sheet
gt; it will adjust for each successive row you wish to consider.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Hakojinquot; gt; wrote in message
gt; news
gt; gt; How can I make this so that it scans all rows on one worksheet for a
gt; gt; match on
gt; gt; the other work sheet? I need it to work similar to a vlookup, but
gt; gt; using the
gt; gt; combination of 2 criteria instead of 1.
gt; gt;
gt; gt; This did work, but it's row specific. Thanks for your help
gt; gt;
gt; gt; quot;Roger Govierquot; wrote:
gt; gt;
gt; gt;gt; Hi
gt; gt;gt; Try
gt; gt;gt; =IF(AND(Sheet1!B2=Sheet2!B2,Sheet1!G2=Sheet2!G2),S heet1!J2,quot;quot;)
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards
gt; gt;gt;
gt; gt;gt; Roger Govier
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Hakojinquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have two worksheets with identical column headings. Column J in
gt; gt;gt; gt;sheet
gt; gt;gt; gt;1 is
gt; gt;gt; gt; blank, Column J in sheet 2 has a date. I need the formula to pull
gt; gt;gt; gt; the
gt; gt;gt; gt; date
gt; gt;gt; gt; from sheet 2 when B and G have the same data on both sheets.
gt; gt;gt; gt;
gt; gt;gt; gt; Column B Column G Column J
gt; gt;gt; gt; Client ID Customer Branch Date
gt; gt;gt; gt; 2435 Eagle Rock
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;