Can you put a hyperlink in a Vlookup formula?

[Steviefiege]

Hi,

Is it possible in a VLOOKUP formula to make the table array a hyperlink to another sheet in a wookbook.

This is my formula: =IF(D6="","",VLOOKUP($B6,DLF!$B$4:$F$20,5,FALSE))

<colgroup><col width="100"></colgroup><tbody>
[TD="class: xl67, width: 100"][/TD]

</tbody>

As you can see, column C is the positions that the player can play in & the formula above is in column E.
What i want is in the formula where it says DLF! to link that to column C which is a hyperlink to another sheet in the same workbook with the same name. Its just so i dont have to change every single line in column E for every player.

B C D E

<colgroup><col style="mso-width-source:userset;mso-width-alt:7314;width:150pt" width="200"> <col style="mso-width-source:userset;mso-width-alt:3657; width:75pt" width="100" span="3"> </colgroup><tbody>
[TD="class: xl70, width: 200"]Alex Kiwomya[/TD]
[TD="class: xl72, width: 100"] CF [/TD]
[TD="class: xl67, width: 100"] [/TD]
[TD="class: xl69, width: 100"] [/TD]

[TD="class: xl71, width: 200"]Alex Kiwomya[/TD]
[TD="class: xl68"]DLF[/TD]
[TD="class: xl67"]DLF[/TD]
[TD="class: xl69"]38.33[/TD]

[TD="class: xl71, width: 200"]Alex Kiwomya[/TD]
[TD="class: xl68"]AF[/TD]
[TD="class: xl67"]AF[/TD]
[TD="class: xl69"]45.00[/TD]

</tbody>