I made a boo boo, sorry - this is what I wanted, if you could
tweak this formula:

=IF(COUNTIF($A$2:$A$14079,G2),D2,"")

to follow this logic it would be appreciated:

if a2 matches g50 the i need to write the results of d2 at J50
and so on.



On Fri, 19 Nov 2004 23:00:48 +0100, "Frank Kabel"
wrote:

Hi
should be of course vice-versa: First formula - for option 1
new formula - for option 2