Matching data in 2 different work sheets

  • Thread starter Thread starter Curtis
  • Start date Start date
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
 
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.
 
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
 
Back
Top