I want to get only the price's encased in brackets in Price EUR cell:
Sheet link: https://docs.google.com/spreadsheets/d/1xoNPfIfrVv7jF8W3Pa67Iu9oJRz2NOncW7oLQ94mWQ4
try:
=IFNA(INDEX(TRIM(ARRAY_CONSTRAIN(SUBSTITUTE(
SPLIT(REGEXEXTRACT($A3, B1&"(.+)"), "]"), "[", ), 1, 2))), 0)