Insert column3 Value if Column1 match to column2

[dcmphi]

I have three column in excel with value. These are A, B and C. I want to insert value of C column in D if A col value=B col
example:
A B C D
5 5 3 3
2 2 5 5
1 1 0 0
9 9 7 7

Can any one help?

 

[Jimmypop]

Hi There

Not sure if this is what you are looking for?

Book1
	A	B	C	D
1	5	5	3	3
2	2	2	5	5
3	1	1	0	0
4	9	9	7	7
Sheet1

Cell Formulas
Range	Formula
D1:D4	D1	=IF(A1=B1,C1,"")

 

[dcmphi]

Hi There

Not sure if this is what you are looking for?

Book1
	A	B	C	D
1	5	5	3	3
2	2	2	5	5
3	1	1	0	0
4	9	9	7	7
Sheet1

Cell Formulas
Range	Formula
D1:D4	D1	=IF(A1=B1,C1,"")

Thanks for reply. I dont want that. I have col A, B and C with values. Col A & B is same type of data but they are not sorting. I want if my col A cell (example: A2) value is match with B col range (B2:B10) then insert C col data which is parallel with B col. I attach a picture.

 

[dcmphi]

My A & B column is Roll No. C column is Marks. B & C column has 1000 rows. But A column has only 5 rows. I want to know the marks against the A1 Roll No which is already exist in B & C column. Which formula i use do that?

 

[Jimmypop]

@dcmphi In you post #3 pic you say that Col A2 matches B10 but it matches B9? So Col D according to your pic is Col C sorted from high to low but keeping the values that match parallel to each other?

Now in post #4 Col A has only 5 rows where in previous it had more? and B and C now has 1000? Apologies but the changing of data makes it quite difficult to see exactly what you want so maybe there is someone else who might understand a bit better as to what is required?

 

[dcmphi]

@dcmphi In you post #3 pic you say that Col A2 matches B10 but it matches B9? So Col D according to your pic is Col C sorted from high to low but keeping the values that match parallel to each other?

Now in post #4 Col A has only 5 rows where in previous it had more? and B and C now has 1000? Apologies but the changing of data makes it quite difficult to see exactly what you want so maybe there is someone else who might understand a bit better as to what is required?

Thank you Bro, i am looking what is in post #4.

 

[Peter_SSs]

Like this?

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

22 08 29.xlsm
	A	B	C	D
1	2	17	101	110
2	4	15	102	109
3	6	19	103	108
4	8	13	104	107
5	9	9	105	105
6	11	11	106	106
7	13	8	107	104
8	15	6	108	102
9	17	4	109	101
10	19	2	110	103
Match

Cell Formulas
Range	Formula
D1:D10	D1	=VLOOKUP(A1,B$1:C$10,2,0)

 

[dcmphi]

Like this?

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

22 08 29.xlsm
	A	B	C	D
1	2	17	101	110
2	4	15	102	109
3	6	19	103	108
4	8	13	104	107
5	9	9	105	105
6	11	11	106	106
7	13	8	107	104
8	15	6	108	102
9	17	4	109	101
10	19	2	110	103
Match

Cell Formulas
Range	Formula
D1:D10	D1	=VLOOKUP(A1,B$1:C$10,2,0)

Thankyou bro but not working.

 

[Peter_SSs]

Thankyou bro but not working.

Care to give a bit more information so there would be a chance to work out why and what you really want?
The results in my sheet column D are identical to column D in your image in post #3. Aren't they the results that you wanted?

 

[dcmphi]

Care to give a bit more information so there would be a chance to work out why and what you really want?
The results in my sheet column D are identical to column D in your image in post #3. Aren't they the results that you wanted?

I want to say column A and column B is like as database table and i want to query in column B from column D column where column C matches with column A then set column B value as a result in column D. For an Example: column A is student roll and column B is marks. Column C is also student roll. I want to query if column C student roll matches with column A student roll then show marks (column B) in column D as a result.