I normally use one cell for the hyperlink some thing like in b11

=concatenate("http://www.whitepages.com/10001/sea...=I2&city_zip=";b10)

and then =Hyperlink(b11;"Hyperlink")

works like a charm exept for the little bug that it oppens a new explore every time

good luck