• 0

Excel help using VLOOKUP


Question

Doing a fairly simple excel table/array with vlookup.

I want to be able to type in a form # and it returns a website address. I am able to have the web address returned but it is not a "link". On my table the address is a link and will open up IE when clicked but on the actual return sheet, it is just text. Is there anyway to have this bring the actual link over?

Thanks!

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

One more question regarding that. If I am trying to change the response message from the vlookup from #N/A to "please verify form # and press enter" is it still possible with the hyperlink?

=IF(ISNA(VLOOKUP($C$3,'Form Information'!$E$2:$F$34,2,FALSE)),"Please verify form # and press Enter", VLOOKUP($C$3,'Form Information'!$E$2:$F$34,2,FALSE))

Link to comment
Share on other sites

  • 0


=IF(ISNA(VLOOKUP($C$3,'Form Information'!$E$2:$F$34,2,FALSE)),"Please verify form # and press Enter", HYPERLINK(VLOOKUP($C$3,'Form Information'!$E$2:$F$34,2,FALSE)))
[/CODE]

Yes... here we have the code which says if this lookup is N/A use this text, otherwise use a hyperlink for the lookup value.

Link to comment
Share on other sites

  • 0

If the range is large, this version should be quicker to calculate:

=IF(ISNA(MATCH($C$3,'Form Information'!$E$2:$E$34,0)),"Please verify form # and press Enter", HYPERLINK(VLOOKUP($C$3,'Form Information'!$E$2:$F$34,2,0)))

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.