Friday, February 1, 2013

yogi_Create Hyperlinks for An Array Of Values For Search Field In Column C


                                          Google Spreadsheet   Post  #1003
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 01, 2013
post by user: Brandon Fishman said:(http://productforums.google.com/forum/?zx=o6rqlebp7ykw#!category-topic/docs/spreadsheets/CLUV5CkzX_g)
Looking to do an Array Formula using a Hyperlink?
My Public URL is https://docs.google.com/spreadsheet/ccc?key=0AnkVRC1UPDUGdGNnYUtOR1lyMHBtVWlDNmJ5eGl6NFE&usp=sharing

I am trying to do a Concatenate Hyperlink. 

This would be used in a form, so I assume it would need to be an array formula but I can't figure it out. 

If a Name is in A3 Take the fomula in A1, and concatenate B3 to the end and display the name, if no  name is present display N/A.
Column D is there just to show my attempt that is failing.  
--------------------------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem