Need some help on a hyperlink formula

I am getting CVS data from SQL, and it has an ID number in column A (starting at A2). We are saving them as xlsx files (excel 365). In column E i want to add in =HYPERLINK(https://company.website.com/info/ and after the info have a link to A2.
Then i can drag it down for a3, a4, etc. So the data in column a appears at the end of the hyperlink.
How would I got about this? I keep getting errors assuming that i dont know this is a formula from excel.

Originally Posted by BigD63

i posted the base link without the reference data in F2. .... But each time i drag the formula down i get "inconsistent formula" error and it changes the F2 to F4 and F5 etc.

Yeah, Excel is changing that because it's a relative reference. You want an absolute reference to F2, which would be $F$2 or at least F$2.
So try that.

OK I will give that a try, but is there a way to not need to paste the link into F2 initially and then make the link? To just have something i can copy paste into each sheet that has the l;ink in it?

Tested and it works.
But I cannot drag it down, when i do it copies, so manually changing it 400 times for this sheet alone is not feasible. What is the next step?

"But I cannot drag it down, when i do it copies, "
Need a clearer explanation or a quickie workbook so I can see what that means.

I'm off tomorrow, so probably someone else will pick this up.

As in, when you click on the bottom right corner of the cell and drag down vertical, so it pulls the formula down to fill in for the additional cells. The current xlsx file has 400 entries. So I need to be able to copy the formula downward and have it adjust for the A2, A3, A4, A5 etc cell values.

Is a version of this even possible? =HYPERLINK(https://company.website.com/info/$A$2) where the $A$2 is the cell reference that goes at the end of the company internal website.

Thanks for the help so far!

Right, but you said that you had: "Copying the url into F2, then in E2 +Hyperlink(F2&A2)"

so just make that: Copying the url into F2, then in E2 +Hyperlink($F$2&A2)
Then the $F$2 is absolute, and the A2 is relative. $F$2 stays the same, A2 becomes A3, A4, A5....

Right, that worked! Thanks. I didnt know that the second $ in A2 locked the 2 into place.