Hello richbrown_staff, thank you for taking the time to explain in detail.
I understood everything, it all worked, but somehow the formula is not correct.
Did you maybe made a mistake, when inserting the formula in H2 in Sheet 1 I get an error in Google Sheet always "Parser error, check the formula syntax).
=IFERROR(VLOOKUP(G2, SORT({Sheet2!G:H, LEN(Sheet2!H:H)}, 3, FALSE), 2, FALSE), “”)
Thanks for a reply in advance.
Kind regards, Elena