Search Rows of Data to Find a Match when Match Location Varies by Column and Return Row #

I have a list of what I call id's in Column A (Ex id="10230" ), then in columns C through NA I have data. Each row from column C to NA contains a cell that also has id that exactly matches one of the ids in my A column. The problem is the Id is almost never in the same column, meaning the matching id for A1 might be in J1023 while the matching id for A2 might be in BB15. There is only one id per row in the C though NA column. There are also empty cells and some rows are longer than others.

In Column B I want to find the row # which contains the matching id as the associated A Column id.

Column A
ex: id="10230"

Column B
this will be the row # that contains the same id as ColumnA (What we are trying to find)

Column C .... Column NA
various letters and numbers of data one of the cells is an id

I uploaded the first 5 rows of my data. Column A has the id's, column B is blank, and from Columns C and on - are the "data" If you see in row 1, the location of the id is at GV1, row2 the id is at HB2 and so on.

In Column B, I want to find which row of "data" contains the id that matches the id in Column A.


By a helper column do you mean just having a column that has a 1 in row 1, a 2 in row 2, a 3 in row 3 ... and so on? If so yeah



Let me know if I can clear anything else up, or if I did a bad job at trying to explain.

Small Snippet.xlsx
------

Works perfectly, I really appreciate it!