Have a look at the HYPERLINK worksheet function.On 2002-08-06 04:18, doug.sloane wrote:
I have 2 columns A & B. I want the 2 columns to be blank until something is typed into a cell in column A. Then I want the corresponding cell in column b to be a url such as "http:www.abc.comsearch=" & A1.content
I'm using the following on the B cell but can't get it to work :
=IF(A1="","",("http://www.abc.com/guestSearch.asp?search=" & A7 &"&name=hello" & A7))
Also if possible I'd like the contents of column B to be protected.
This is fairly urgent (well for me, obviously not for ye lot) so any help would be much appreciated.