Suppose I have similiar table [over 200 rows and over 80 columns], but with B column as additional description of "vendorname", and with others (column C and rightwards) filled with formulas returning either TEXT or "".
You wrote: "=IFERROR(INDEX(...),"") shows empty cell after displaying all data".
What, if I'd like formula to continue returning texts from the next rows (vendorname_1, vendorname_2 and so on)?
And I can't imagine, how to use MATCH in such a case.
I think of a formula that "knows": 'OK, there's no text in this row (vendorname_1) anymore, let's offset one down (vendorname_2) and egzamine it'.
I'd like to end up with three-column wide table, where in first two columns appropriate "vendorname" and "description of vendorname" are repeated as long, as there are text values (data) being returned by formula in the third for that particular "vendorname"...
Any help would be greatly appreciated! (And sorry for my english.) Best regards.