google sheets - How do you reference a cell in quotations using the IMPORTXML formula?

Question

I am wanting to reference a cell for the URL section as well as the xpath_query section of the IMPORTXML formula.

Because the XPath formula requires the inputs to be in quotations the cell references no longer work.

What would you suggest for the following formula? =IMPORTXML(C2,B7)

C2 = https://www.example.com B7 = //nav[@aria-label='test']

question from:https://stackoverflow.com/questions/65892951/how-do-you-reference-a-cell-in-quotations-using-the-importxml-formula

Answer 1

try:

=IMPORTXML(C2&B7; "//*")