mercredi 14 octobre 2020

How do I add another ImportXML function to the same cell and have that XML function activate if another cell has specific text in it?

I need help with having E17 change depending on what D17 cell has.

=IF(RegExMatch(D17,"Amazon"), ImportXML("https://www.amazon.com/dp/"&C17,"//span[@id='productTitle']"))

How do I add another ImportXML function if D17 has Walmart or Overstock is in the cell?

I'll need help finding the Walmart search link as well so when D17 has "Walmart" auto inputted it searches the Walmart registry for the IN#'s title. Thank you! Hope I provided enough insight. I own an eCommerce business and this will help me a lot.

If you can find a way to do it with any market site that would help a lot as well.

Spreadsheet Example

Aucun commentaire:

Enregistrer un commentaire