Index and Match formula translated to VBA

[Mikeymike_W]

Hi All,

Thanks in advance for any help you can give.

I have a form in which i have the following formula linking a cell to another workbook to extract a value using the formula:

=IFERROR(IF((INDEX(FIPCDNumber1,MATCH(PID,PIDFIP2,0)))=0,"",(INDEX(FIPCDNumber1,MATCH(PID,PIDFIP2,0)))),"")

FIPCDNumber1='FIP.xlsm'!DATATable[CD Number]
PID=cell within the form
PIDFIP2='FIP.xlsm'!DATATable[PID]

Everytime the form opens it comes with the update links error. This form will be sent externally so i cant have this.
I have a user form which i use to assign certain details and i thought i could have a command button which could activate the link to the other workbook and extract the info which the formula was used for and have it populate a textbox on the user form.
This way the error may not appear and is still easy enough to use.

Any help on how to do this or any better ideas would be welcome too!!