Hi,
I've searched the archives and though I've found similar issues I haven't been able to figure this one out. I have a list of IDs in column A on worksheet 1. One worksheet 2 I have a vlookup returning modality and length, but in cases where there is more than one modality or length I can't get them concatenated (modality) or summed (length). The summing is the biggest thing I want to solve for, modality will just be a bonus.
I see that I can do this with an array formula, but since I have 648 rows of values I can't use a formula that has {1,2,3,4,5... all the way to 648}. I can't see another way of doing it. I'm not sure if I need to do something with index or match? Can anyone help?
<tbody>
</tbody>
=vlookup(A2,table1,2,false)
=vlookup(A2,table1,3,false)
Thanks!
I've searched the archives and though I've found similar issues I haven't been able to figure this one out. I have a list of IDs in column A on worksheet 1. One worksheet 2 I have a vlookup returning modality and length, but in cases where there is more than one modality or length I can't get them concatenated (modality) or summed (length). The summing is the biggest thing I want to solve for, modality will just be a bonus.
I see that I can do this with an array formula, but since I have 648 rows of values I can't use a formula that has {1,2,3,4,5... all the way to 648}. I can't see another way of doing it. I'm not sure if I need to do something with index or match? Can anyone help?
ID | MODALITY | LENGTH |
1001 | LMS | 3 |
1002 | LMS | 2 |
1002 | LOR | 5 |
<tbody>
</tbody>
=vlookup(A2,table1,2,false)
=vlookup(A2,table1,3,false)
Thanks!
Last edited: