vLookup to return ALL instances of the same value - please help

[Legacy 319254]

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.)

A B C D E F G 1 Weld Suffix Daily Query (input) Vlookup result (output) 2 1156 1156 1156 0 3 1157 1158 1158 0 4 1158 1161 1161 0 5 1158 C1 1162 1162 T4 6 1158 C2 1169 1169 T1 7 1160 1170 1170 T2R1 8 1161 9 1162 T4 Desired Result (output) 10 1163 1156 11 1164 1158 12 1165 1158 C1 13 1166 1158 C2 14 1167 1161 15 1168 1162 T4 16 1169 T1 1169 T1 17 1170 T2R1 1170 T2R1 18 1170 T2 1170 T2 <tbody> </tbody>

<tbody>
</tbody>

Many thanks and I greatly appreciate your assistance!

 

[chicagocomputerclasses]

Convert A-B column data to a table.
Convert D column data to a table.
Use PowerQuery Merge. Use D column table as the primary table.

You may need to download and install this first
Download Microsoft Power Query for Excel from Official Microsoft Download Center

 

[RoryA]

If you don't have the correct version/SKU to get Power Query, you could use the native Advanced filter with your column D range as the criteria - you just need to make sure the header matches the header in the main data table. You can either filter in place or copy to a new location.