DOUBLE POST--Sorry wrong category first--Convert to VB Pleaseeee

Can someone please write this in VB for me because when i drag this down 20,
000 rows and 10 columns across.....I get quite the file. Can you make it so
that it says N/A for ones that it doesn't find. Id like to be a macro that i
just run that does it for me "real quick".

=IF(Code1=ifthen.xls!CODECOL,INDEX('[ifthen.xls]Final Merge Fields'!$1:$65536,

MATCH(A47947,'[ifthen.xls]Final Merge Fields'!$A:$A,0),MATCH("Code",'[ifthen.
xls]Final Merge Fields'!$1:$1,0)),"")

Thank you sooo very much in advance.

Derek


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200507/1

you people blow

Derek Y wrote:
>Can someone please write this in VB for me because when i drag this down 20,
>000 rows and 10 columns across.....I get quite the file. Can you make it so
>that it says N/A for ones that it doesn't find. Id like to be a macro that i
>just run that does it for me "real quick".
>
>=IF(Code1=ifthen.xls!CODECOL,INDEX('[ifthen.xls]Final Merge Fields'!$1:$65536,
>
>MATCH(A47947,'[ifthen.xls]Final Merge Fields'!$A:$A,0),MATCH("Code",'[ifthen.
>xls]Final Merge Fields'!$1:$1,0)),"")
>
>Thank you sooo very much in advance.
>
>Derek


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200507/1