Excel - pull data from a cell based on MATCH

Microsoft Excel 2003 (full product)
August 6, 2010 at 10:47:34
Specs: Windows XP
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 = BJ7

THANKS!


See More: Excel - pull data from a cell based on MATCH

Report •


#1
August 6, 2010 at 19:30:43
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 61

Finally 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


Report •
Related Solutions


Ask Question