View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Comparing two sets of data

Sorry, correction to formula in G2 of Sheet1
(the earlier one given was actually for G3)

Put instead in G2 of Sheet1:

=IF(ISNA(MATCH(TRIM($A2&"
"&$B2),Sheet2!$G:$G,0)),"",OFFSET(Sheet2!$A$1,MATC H(TRIM($A2&"
"&$B2),Sheet2!$G:$G,0)-1,COLUMN()-5))

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---