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
---
|