join two colums on different sheets and make hyperlink 1

[max1x]

In sheet1, coulum A I have
a
b
c
d
e
In sheet2, colum I have

http://somelink=

In sheet1, I did the following in column B
HYPERLINK("sheet2!A1"&"sheet2!A1",A1)
which creates

http://somelink=a

The problem is that when I copy the forumla down in the column on sheet1, colB, it keep on adding 1 to the sheet2 lookup, which I don't want to happen.

Any ideas.

 

[xlbo]

I'm not sure that is your formula as it would not do as you describe but I think you just need to change A1 to $A$1

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[max1x]

Thank you for your help. I played aroudn with it and got it to work.

=HYPERLINK(workSheetName!A$1&colToConc,valOfcolToConc)