Credit note log

Hi Again

i am reverting back to my log which RayUK kindly helped me with. i understand now how to pull certain information from certain places and place it it somewhere else. My new question is about formatting.

i am adding email adresses using the vlookup formula but would like it to be formatted so that it resembles a hyperlink and opens up your email client. in the example file shown i have written my email adress which works fine but the when i click on the suppliers email it just brings up the formula.

any ideas.

Phil

No attachment

An email address normally autoformats to underlined blue & a hyperlink

You have two email addresses in one cell so Excel doesn't recognise the format

What do you mean "pulled across"?

I thought that you meant the log sheet. Try this in A9 of the actual form

=HYPERLINK(VLOOKUP(C16,Suppliers!$A$1:$C$60,3,FALSE))

Works for me. have you got calculation set to automatic?

Here's your example that i added the formula to

Hi Roy

i thought you had cracked it. i get the email address in the correct format but when i click it it says

"Cannot open the specified file"

any thoughts as we are so close?

i did notice that on the email adress i have written in ie QC if you hover over the top it says mailto: and the other dosnt

Phil

I've looked into this but I have found the problem reported, but not solved.

I think maybe start a new thread with "VLOOKUP email address results in error"

Add a link to this post

Well done, & thanks for sharing