View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default 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