| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching data in 2 different work sheets
In Sheet 1
Column G contains the PO# Column I contains the $ rows are 6 to 333 In Sheet 2 Column G contains the PO# Column I contains the $ rows are 6 to 333 I need a formula that will reside in Column H rows 6 to 333 in sheet 1 that will look at sheet 2 to and if the data in G6 thru G333 matches and I6 and I333 match to say yes otherwise no thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching data in 2 different work sheets
Hi,
=if(and(G6=sheet2!G6,I6=sheet2!I6),"Yes","No") "Curtis" wrote: In Sheet 1 Column G contains the PO# Column I contains the $ rows are 6 to 333 In Sheet 2 Column G contains the PO# Column I contains the $ rows are 6 to 333 I need a formula that will reside in Column H rows 6 to 333 in sheet 1 that will look at sheet 2 to and if the data in G6 thru G333 matches and I6 and I333 match to say yes otherwise no thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching data in 2 different work sheets
Sorry I obviously wasn't clear enough but the data in Sheet 2 may not be in
the identical row as the data in sheet 1. "Curtis" wrote: In Sheet 1 Column G contains the PO# Column I contains the $ rows are 6 to 333 In Sheet 2 Column G contains the PO# Column I contains the $ rows are 6 to 333 I need a formula that will reside in Column H rows 6 to 333 in sheet 1 that will look at sheet 2 to and if the data in G6 thru G333 matches and I6 and I333 match to say yes otherwise no thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching data in 2 different work sheets
Hi,.
try =IF(ISNA(AND(MATCH(G6,Sheet2!$G$6:$G$1000,0),MATCH (I6,Sheet2!$I$6:$I$1000,0)))=FALSE,"Yes","No") change range to fit your needs "Curtis" wrote: Sorry I obviously wasn't clear enough but the data in Sheet 2 may not be in the identical row as the data in sheet 1. "Curtis" wrote: In Sheet 1 Column G contains the PO# Column I contains the $ rows are 6 to 333 In Sheet 2 Column G contains the PO# Column I contains the $ rows are 6 to 333 I need a formula that will reside in Column H rows 6 to 333 in sheet 1 that will look at sheet 2 to and if the data in G6 thru G333 matches and I6 and I333 match to say yes otherwise no thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching data in two sheets | Excel Discussion (Misc queries) | |||
| Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
| Matching & retrieving data across sheets | Excel Discussion (Misc queries) | |||
| Help with 2 sheets with data to work together | Excel Worksheet Functions | |||
| Vlook up for matching data in two seperate sheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
