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
convert columns to rows 6
Countif or other formula needed for multiple data/critera results 3
Matching Data 1
Remove Identical words 0
Found few bugs in my daily routine of work in excel for MAC 0
Copy Data from 1 Sheet to Another 3
Need Help with a VBA subroutine 0

Top