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    Feb 01, 2013
post by user: Brandon Fishman said:(!category-topic/docs/spreadsheets/CLUV5CkzX_g)
Looking to do an Array Formula using a Hyperlink?
My Public URL is

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