Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling date from 1 ws to another while referencing 2 fields
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling date from 1 ws to another while referencing 2 fields
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling date from 1 ws to another while referencing 2 fields
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling date from 1 ws to another while referencing 2 fields
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling date from 1 ws to another while referencing 2 fields
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
Count the occurances of a month in a range of date fields | Excel Worksheet Functions | |||
Formatting date fields after export | Excel Discussion (Misc queries) | |||
Sum function on multiple date fields | Excel Worksheet Functions |