Hi everybody.
I'm doing an assignment for my work and have come to a problem I don't know how to solve.
I have a table where the first row contains a number of the column and under that number there are 8 digits in another 8 rows (code for binary digits). Every next column containes the next code for binary digits (again in 8 rows). Under the data, I have another column with 8 rows, where I will randomly input the combination of binary code digits and would in the end like that Excel returns the number of the column from upper (main) table. Thus finding a range of cells in another range of cells.
I'm attaching the Excel file to help with the "imaging" of the problem.
Could this be done with INDEX + something else, or will I need programming?
Should there be any additional questions or misunderstanding about my wishes, please don't hesitate to ask.
Thank you for your help in advance.
Bookmarks