I DID IT!!!!!

=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)),"")

YESSSS i'm so excited

Derek Y wrote:
I learned how to copy VB code and run it as a macro?? :) haha should i just
get a book and read up on INDEX and MATCH functions??

I think I need to do something like that IF or VLOOKUP so that I can pick the
column it should go in.... but i'm still pretty lost.


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