Horizontal lookup based on CurrentRow

[mbuehler (MB)]

I am trying to lookup a specific code based on the “Training Name” Column in the above table which was imported into a datatable “dt_CSR”. Each training has it’s own 3 digit code. If that code is present, then the “Vectored” column of that row needs to be updated to “True”.

The 3 digit code would need to be in the same row, but can be in any column after column G.

For example, Row 2. Training name is “Annuity” and it’s code is 424 shown in column K. Since it exists, cell D2 would need to be updated to “True”.

I am not sure how to approach this so all feedback is welcomed. Thank you.

[mbuehler (MB)]