using VLOOKUP in Excel to fetch a JIRA LINK

Nathan Cuper

Hi everyone.

I understand that this is more of a Excel Question than a Jira Question, but alas, my google-fu is too weak. and I couldn't get an answer.

i'm geting a report from our intern issue tracker, then I get a report from jira. in bouth reports (excel) we use an identificator ID to do the match from our legacy tracker to JIRA.

 

then, I use Vlookup to fetch info from the Jira report (same excel, different sheet) to my custom report. my problem is when I fetch the Jira link ( Jira Key ej: C123456C-3223) it doesnt bring the link. I've tried hyperlink but it gives me this error: "cannot open the specidfied file)

I'm using this formula:

=(VLOOKUP([@[CAMP ID]];general_report!$A$1:$Q$216;17;0))

Earl McCutcheon

Hi Nathan,

To get the hyperlink to copy over try nesting vlookup in the hyperlink function and using the function like this to get the output cell to carry over the hyperlink value of the input field:

=HYPERLINK(VLOOKUP()) 

Regards,
Earl