Excel if statements - if id match, lookup key word in the same row, if key word found, fill in with value to the right of where key word was found

Excel mess:

I have a worksheet with data all over the place: - Each row has a number (identifier) - The number identifier is in column J and isn't unique (there can be 3 or 4 rows having the same number identifier containing more info about the same security - The info I am looking for (Ex: CDS ID) is found in one of the rows where the identifier match but isn't always in the same column. However, when the key word 'CDS ID' is found and the identifier in the column match, the CDS ID number which I am looking for is in the next column from where the key word was found.

Need to do: - I want to write a condition so that for each security in the table I am creating, in the CDS ID column, it looks up the original table, finds where the identifier number matches and then looks up the row to try to find where the key word 'CDS ID' is found and then fills the spot with the value (number) found to the right of where the key word was found in the original table.

I am aware this sounds pretty confusing. Sorry about that.