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?

 

[Peter_SSs]

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.

Please give us some more realistic small sample dummy data with the expected results (filled in manually) with XL2BB and explain again in relation to that sample data.

 

[dcmphi]

Please give us some more realistic small sample dummy data with the expected results (filled in manually) with XL2BB and explain again in relation to that sample data.

I discover the formula. Here is it.
=VLOOKUP(C6,$A$4:$B$9,2,0)
But one problem if C6 value is null it shows #N/A Can i solve it if C6 is null then result shows 0?

 

[Jimmypop]

I discover the formula. Here is it.
=VLOOKUP(C6,$A$4:$B$9,2,0)
But one problem if C6 value is null it shows #N/A Can i solve it if C6 is null then result shows 0?

=IFERROR(VLOOKUP(C4,$A$4:$B$9,2,0),"0")

 

[Peter_SSs]

I discover the formula. Here is it.
=VLOOKUP(C6,$A$4:$B$9,2,0)

Well, that is quite a different layout/description to what you originally posted. No wonder the early suggestions did not work for you.

Here are some other options, depending on which of your Excel versions you are actually using for this job and exactly what output you want if column C is empty.

22 08 29.xlsm
	A	B	C	D	E	F	G	H	I
1
2
3
4	55	Passed	25			fail	fail	fail	fail
5	52	fail				0		0
6	25	fail	55			Passed	Passed	Passed	Passed
7	54	fail	689			Passed	Passed	Passed	Passed
8	689	Passed				0		0
9	256	Passed				0		0
Match (2)

Cell Formulas
Range	Formula
F4:F9	F4	=IF(C4="",0,VLOOKUP(C4,$A$4:$B$9,2,0))
G4:G9	G4	=IF(C4="","",VLOOKUP(C4,$A$4:$B$9,2,0))
H4:H9	H4	=XLOOKUP(C4,A$4:A$9,B$4:B$9,0)
I4:I9	I4	=XLOOKUP(C4,A$4:A$9,B$4:B$9,"")