Inserting an INDEX,MATCH function into a HYPERLINK function instead of cell reference

Hi everybody,

Another interesting dilemma to solve.

Using this formula:

=HYPERLINK("http://www.website.com/registry_images/" & C4 & "/" & G4 & "/" & C4 & "_" & INT(LOOKUP(9.99E+307,--MID(D4,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D4&1234567890)),ROW(INDIRECT("1:"&LEN(D4)))))) & ".jpg")

from the thread: http://www.excelforum.com/excel-misc...ing-cells.html

I need to replace D4 with something along the lines of:

=IF(INDEX(Codes!A:D,MATCH(A3258,Codes!A:A,0),3)=0,A3258,INDEX(Codes!A:D,MATCH(A3258,Codes!A:A,0),4))

I am making this much harder than needed as a lot of the information in the cells are not entered directly into the cell, but functions referencing other worksheets. Any ideas on how to go about this? I am sort of familiar with the INDEX&MATCH functions but wasn't sure how to insert it into the HYPERLINK function.

Thanks,
Chris