Pulling date from 1 ws to another while referencing 2 fields

[Hakojin]

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

[Roger Govier]

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

--
Regards

Roger Govier


"Hakojin" <Hakojin@discussions.microsoft.com> wrote in message
news:AF058B0A-F3D4-49BB-9D25-F13515C8F644@microsoft.com...
>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

[Hakojin]

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),Sheet1!J2,"")
>
> --
> Regards
>
> Roger Govier
>
>
> "Hakojin" <Hakojin@discussions.microsoft.com> wrote in message
> news:AF058B0A-F3D4-49BB-9D25-F13515C8F644@microsoft.com...
> >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
>
>
>

[Roger Govier]

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" <Hakojin@discussions.microsoft.com> wrote in message
news:D5FB79B9-BF7A-46B2-BEE7-0F5BBE2C2E42@microsoft.com...
> 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),Sheet1!J2,"")
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "Hakojin" <Hakojin@discussions.microsoft.com> wrote in message
>> news:AF058B0A-F3D4-49BB-9D25-F13515C8F644@microsoft.com...
>> >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
>>
>>
>>

[Hakojin]

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" <Hakojin@discussions.microsoft.com> wrote in message
> news:D5FB79B9-BF7A-46B2-BEE7-0F5BBE2C2E42@microsoft.com...
> > 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),Sheet1!J2,"")
> >>
> >> --
> >> Regards
> >>
> >> Roger Govier
> >>
> >>
> >> "Hakojin" <Hakojin@discussions.microsoft.com> wrote in message
> >> news:AF058B0A-F3D4-49BB-9D25-F13515C8F644@microsoft.com...
> >> >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
> >>
> >>
> >>
>
>
>