L
Legacy 319254
Guest
Greetings,
I've viewed your board posts for years in college, as I dabbled in VBA and found it most useful, but have not used advanced Excel in years. I know vLookup has severe limitations when it concerns duplicates (or anything with multiple instances of the same 'matched/returned' value). My issue is I'm needing to have a column list returned (which shall contain duplicates) AND with any appended data on its right [column] returned along side each result. The problem i'm faced with is a simple vLookup only lists a single instance. And as the instance-number varies it cannot be hard-coded.
Please see below. Note: all formatting is for emphasis and not required.
Left two Weld Data columns are raw data.
Middle green column is a manually entered list of each unique record ID's that need to be queried/returned (only typed in once- as i don't know if any will have multiple instances).
Red table VLookup is the current output sample.
Blue table is what I'm needing as output. (Note the red records are the 2nd or more instance of the same value.)
<tbody>
</tbody>
Many thanks and I greatly appreciate your assistance!
I've viewed your board posts for years in college, as I dabbled in VBA and found it most useful, but have not used advanced Excel in years. I know vLookup has severe limitations when it concerns duplicates (or anything with multiple instances of the same 'matched/returned' value). My issue is I'm needing to have a column list returned (which shall contain duplicates) AND with any appended data on its right [column] returned along side each result. The problem i'm faced with is a simple vLookup only lists a single instance. And as the instance-number varies it cannot be hard-coded.
Please see below. Note: all formatting is for emphasis and not required.
Left two Weld Data columns are raw data.
Middle green column is a manually entered list of each unique record ID's that need to be queried/returned (only typed in once- as i don't know if any will have multiple instances).
Red table VLookup is the current output sample.
Blue table is what I'm needing as output. (Note the red records are the 2nd or more instance of the same value.)
<tbody> </tbody> |
<tbody>
</tbody>
Many thanks and I greatly appreciate your assistance!