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