Pull value from column to another cell, formula help

[capex]

I am trying to pull value from column B based on Value in cloumn A, populate column C with value from Column B. I have repeted value in Column A. Example.

Column A Column B Column C
AT 400 400
CT 300 -100
GT 200
AT -100
CT 200
GT 300

I want to populate column C cells with valued from B based on Value AT from Column A. Please help, Thank you in advance.

AD

 

[capex]

Anybody want to take shot at this, please help.., Thanks.

Column A: AT,CT,GT,AT,CT,GT....Keeps repeating.
Column B: 400,300,200,-100,200,300...

Want to see this result (400,-100) in column c based on value "AT" (Column A) and related value from Column B.

AD

 

[jberwald]

So your column C will only be transposing column B information? And it will always be the info coming from Column A's "AT" rows?

On this premise:
Your next row (row 7) will be "lets say" : AT 400

and you want row 3 to fill in column C: 400

 

[Peter_SSs]

If the values in column A repeat regularly, then try something like this C2 formula, copied down.

Excel Workbook
	A	B	C	D
1	Code	Number	AT	4
2	AT	400	400
3	CT	300	-100
4	GT	200	6
5	AT	-100	8
6	CT	200
7	GT	300
8	AT	6
9	CT	5
10	GT	3
11	AT	8
12	CT	9
13	GT	4
14
Fill Values

 

[capex]

Yes, row 3 in Column C will be 400, AT resides in dropdown menu with CT, GT and many more, currently there are seven items and more will be added on. Thank you for looking in to it.
AD

 

[capex]

Thank you Peter SSs for helping me out, formula did not work on my sheet. Example I have provided here has three repeating value, on my sheet I have seven and will be adding more in future. Does that have anything to do for it not working on my side? I am sorry I am not good with excel but learning. Thank you.

AD

 

[Peter_SSs]

Thank you Peter SSs for helping me out, formula did not work on my sheet. Example I have provided here has three repeating value, on my sheet I have seven and will be adding more in future. Does that have anything to do for it not working on my side? I am sorry I am not good with excel but learning. Thank you.

AD

Yes, if you have other than 3 repeating values, my formula will not work.

Try this instead. It does assume that the values in column A repeat regularly.

If you have more than 1,000 rows of data then change each 1000 in my formulas to something bigger than the number of rows you are likely to encounter.

Formula in C2 is copied down.

Excel Workbook
	A	B	C	D	E	F
1	Code	Number	AT		Count	4
2	AT	400	400		First Row	2
3	CT	300	-100		Spacing	3
4	GT	200	6
5	AT	-100	8
6	CT	200
7	GT	300
8	AT	6
9	CT	5
10	GT	3
11	AT	8
12	CT	9
13	GT	4
14
Fill Values

 

[capex]

Peter, Thank you it worked perfectly. What do I need to do in future when I add another value in column A? any value above that will not change but from certain date it will have 8 or 9 or more values. I can not thank you enough, I appreciate your help. AD.

 

[Peter_SSs]

What do I need to do in future when I add another value in column A? any value above that will not change but from certain date it will have 8 or 9 or more values.

Are you saying that when another value is added that the repeating pattern is not the same for the whole column? Something like below where the pattern changes at the change of colour?

Excel Workbook
	A
1	Code
2	AT
3	CT
4	AT
5	CT
6	AT
7	CT
8	AT
9	CT
10	GT
11	AT
12	CT
13	GT
14
Fill Values

 

[capex]

Pattern remains same till only one or more is added at the end

1st Pattern: AT BT CT DT ET FT GT After some time as needed I will add
2nd Pattern: AT BT CT DT ET FT GT HT IT

2nd pattern has now 9 values, entire pattern will be added form A250 (assuming on that cell two more value needed to be added) it will look like

AT BT CT DT ET FT GT AT BT CT DT ET FT GT AT BT CT DT ET FT GT (Change of pattern) AT BT CT DT ET FT GT HT IT AT BT CT DT ET FT GT HT IT

I am using this calculation in clients investment database two letter represents client's initial, as I add more client I need to add them in this sequence but previous sequence should not be compromise because they remain my client, if I lose a client then I have to remove them from the day they are removed so sequence can reduce as well.

Do I need to change formula from date clients are added? I played with what you have provided but not much success. Thank you for spending time and helping me on this issue.