mercredi 4 septembre 2019

Can i use Regextract with IF so if the text i want not found the formula searches for another term?

I use Regextract with Trim to cute phrases and variables out of the paragraph, the thing is that not all the time the paragraph has the same text but the values and variables are easy to get.

Now I want to have regextract works with IF so if found XX in the paragraph then enters the value next to it using TRIM, if not use another parameter to search and insert its value.

Please check the example, it should be more clear:

https://docs.google.com/spreadsheets/d/1pUUTnbun3lhdOj1ejPQgbRMpXU8C6_HZ3ZWWDXc_3do/edit#gid=0

Aucun commentaire:

Enregistrer un commentaire