doug.sloane
New Member
- Joined
- Jun 18, 2002
- Messages
- 13
Hi
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.
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.