ID | Vlookups? | Col1 | Col2 | Col3 | Col4 |
1 | 34 | 45 | |||
2 | 20 | 25 | 29 | 30 | |
3 | 10 |
<tbody>
</tbody>
Hi All - I have the following table. First column is an ID. The following columns (ignoring Vlookups) are a number of additional IDs that relate to the IDs in the column. (e.g. IDs 34 and 45 are inputs for ID 1).
I'm looking for some formula that can vlookup the IDs in Col1, Col2, etc and return the Names of the ID - The Names of the ID are in another tab, simple two column list A = IDs, B = Names.
My difficulty is how to tell the vlookup up formula to keep adding the fomula until it hits a blank Column - e.g. no more related IDs.
For example,
row 1 will return "ID34 Name; ID45Name"
row 2 will return "ID20 name; ID25 name; ID29 name; ID30 name"
row 3 will return "ID10"
I'm not being lazy btw, some rows in my data have 45 related IDs (split into 45 columns) and other rows only have 2.
Thanks.