Return Vlook up as Hyperlink

[Shazz]

[FONT=&quot]Hi All,[/FONT]

[FONT=&quot]I have the below formula but I want it to return it as a hyperlink as it looks up email addresses, can any one show me how to adapt.[/FONT]

[FONT=&quot]=IF($A3="","",IF(INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1)="","",INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1)))

Much appreciated

Shazz
xx[/FONT]

 

[bobsan42]

[COLOR=#141414]=IF($A3="","",IF(INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1)="","",[/COLOR]HYPERLINK("mailto:" & [COLOR=#141414]INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1))))[/COLOR]

if want it to look nicer:

=IF($A3="","",IF(INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1)="","",HYPERLINK("mailto:" & INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1),INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1))))

if you want it to be formatted as hyperlink:

=HYPERLINK(IF($A3="","",IF(INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1)="","",HYPERLINK("mailto:" & INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1),INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1)))))

However doing the same lookup several times (your original formula does it twice without any good reason) is not really efficient - with a lot of data your formulas may slow down calculation significantly.

 

[Shazz]

Hi This does not seem to be working for me, it just shows the formula in the cell that should be showing the email address.

 

[bobsan42]

Is you cell formatted as General or as Text ?
Have you put = at the beginning of the formula?

A formula is a formula - it shows a result or an error ? No other way?
When you copy Paste the formula it is best to enter the cell in Edit mode (not to simply select the cell and Paste over it).

Format the cell as General
Then double click in the cell paste the formula inside and press enter.