Transform entered Text into a clickable Hyperlink via VLOOKUP

Hi there,

i am Stoney and new to this forum. Glad to meet you guys/girls

I hope you have an idea how this could be achieved:

I have an excel 2013 file with two sheets. When you enter a 5 digit Number (its a school training/lesson number) into B21 (for example) it matches the number against sheet 2 and writes the course/lesson/training name into C21. This works with a formula like this:

=IF(TRIM(B21)="";"";VLOOKUP(TRIM(B21);ModuleSoSe2016!A:B;2;0))

Sheet two has the following rows and data:

A = Lesson number
B = Lesson Name
C = Type of Lesson
D = URL of Lesson

When i enter the lesson/course number into B21, i want to have excel to underline the lesson number and put the hyperlink information of Sheet 2, Row Dx in B21.

Is that possible ? If so - how ? I cannot have the formula in B21 because i need to enter the 5 digit lesson number into that cell.

Would be cool if anyone has an idea how to make this work

Have a great time and thanks for your help in advance!

Stoney

Hi Norie,

i was afraid of that

Having it in a different cell is kind of unsexy i think. I cannot code VBA though

Can someone help me with the VBA code ? Would really appreciate it.

KR
Stoney