Using ImportXML to pull URL and anchor of link containing the string

Question

I'm trying to use ImportXML in Google Sheets to pull URL and anchor of link containing the string. Problem is that I want to avoid having string hardcoded and want it to be pulled from another cell.

Hardcoded example:

=IMPORTXML("http://www.debian.org/mirror/list", "//a/@href[contains(., 'about')]")

Desired outcome (using A2 instead of about):

=IMPORTXML("http://www.debian.org/mirror/list", "//a/@href[contains(., A2)]")

I tried putting A2 in quotes but that didn't work.

Answer 1

Please try:

=IMPORTXML("http://www.debian.org/mirror/list", "//a/@href[contains(.,'"&A2&"' )]")  

ie single quotes (as before) around double quotes around &s.