Is there any way to get an error text from the formula in Google Spreadsheets?
For ex., I see the following error -
Ошибка В диапазоне функции VLOOKUP значение "zzz" не найдено.
(the value 'zzz' not found)
I would like to extract 'zzz' from the error text.
I can not refer to the cell text, since the formula here looks like
=JOIN(", ";ARRAYFORMULA(VLOOKUP(SPLIT(A1;" ");'mapping table'!A:B;2;FALSE)))
Upd. here is the sample table - https://docs.google.com/spreadsheets/d/1gsY68pmymEUzVWZm8z5G5zuShWzkBEt3Y1Wbsu0jtZs/edit?usp=sharing, the expected value is given in cell D1. I would like to get it from the error text.