More like this:

=IF(ISNA(VLOOKUP(A2,G:G,4,FALSE)),"No","Yes")

If for example A2 was found at G50, the I want the value
of D50 to be written at J2.





On Fri, 19 Nov 2004 22:41:59 +0100, "Frank Kabel"
wrote:

Hi
if I understood you correctly you need VBA to loop through your A2:An
range and change column J accordingly. ut of course you could try the
following in J2:
=IF(COUNTIF($A$2:$A$10,G2),D2,"")
and copy this down