I would like to find a value from a table. 10 000 + rows and 90 columns.

The primary values is somewhere in the middle and can be in a diffirent column.

With the row number I want to find 8 more values from diffirent columns.

Within all this confusion the only constant is the colomn headers

I tried the ROW, ADRESS, INDEX and ADDRESS functions and I could not get any one or combination to work.

Please help.