I want to create a new column of data pulling data from one cell in a row. The problem is the particular column in that row is variable. I've created a MATCH and a new column with a number that corresponds to a cell number that ranges from 12 to 61 (or N to BJ).

So, for example, I have a something like this.Column A: values 12, 12, 18, 19, 19, 25, 61

Columns B through BJ have various data (numerical and text, although if its important its numerical data I am collecting)Result:

BK1 = N1

BK2 = N2

BK3 = T3

BK4 = U4

BK5 = U5

BK6 = AA6

BK7 = BJ7THANKS!

Hi, You said

I want to create a new column of data pulling data from one cell in a row. The problem is the particular column in that row is variable

This is confusing - you want to pull one cell in a row -

i.e the cell is somewhere on a specific row.

but you say that the 'particular' column in that row is variable.Does this mean that you want to create a row based on a value in a cell in a row - but the row is variable -

If so what is the data or condition that allows you to select that column. You say that the column is variable but there must be a specific way to identify the column.Then you say:

I've created a MATCH and a new column with a number that corresponds to a cell number that ranges from 12 to 61 (or N to BJ)

Do you mean 12 to 61 are row numbers or are they columns N to BJ (which are columns 14 to 62)

You need to post the MATCH() function you are using, as your description of 'creating' a MATCH function and a new column is, to say the least, not intelligible - there is no way I could recreate your formula from this description.How have you / your formulas 'created' a new column that corresponds to a cell number (does number mean cell row - or cell column and if it's a single number - where does the column [or row] value come from).

You then refer to

Columns B through BJ- how do these relate to N to BJ or 12 to 61Finally you show a series of values in column BK:

Is column BK your 'new' column and if so what is the formula / calculation that creates the relationship to cells N1, N2, T3, U4, U5, AA6 and BJ7. In other words how do you get from BK5 to N5, and then BK6 to AA6 and so on.Please provide specific data and examples that show relationships between cells, as well as specific answers to the issues referred to above.

Regards

Ask Your Question

Weekly Poll

Do you think Google's new Pixel 4 will gain traction?

Discuss in The Lounge

Poll History