Matching data in 2 different work sheets

C

Curtis

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
 
C

Curtis

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.
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and delete rows on two different sheets from reference numbers 4
Matching Data 1
Copy Data from 1 Sheet to Another 3
Sumproduct 4
Need VLOOKUP to Work Two Ways 0
Refernce 2 sheets & same columns & rows 8
Lookup between sheets, finding a match, and returning a letter 3
copy cell info to other sheets, other sheets dont contain all row. 1

Top