Vlookup to search a value from another column

[tobimac]

Hi Everyone,

I'm trying to create a simple lookup to search column B and D and fill Column C if column B and D matches.

For example, since Column B and D value (106th Street Tires and Wheels) matches, I would like to fill the value of Column A (106STR) on Column C.


[TABLE="width: 621"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]CustomerNo[/TD]
[TD]Company Name [/TD]
[TD]CustomerNo[/TD]
[TD]Company Name [/TD]
[/TR]
[TR]
[TD]106STR[/TD]
[TD]106th Street Tires and Wheels[/TD]
[TD][/TD]
[TD]106th Street Tires and Wheels[/TD]
[/TR]
[TR]
[TD]A1CER[/TD]
[TD]A1 Cerified Auto[/TD]
[TD][/TD]
[TD]A1 Cerified Auto[/TD]
[/TR]
[TR]
[TD]ABSLUX[/TD]
[TD]ABS Luxury Wheels[/TD]
[TD][/TD]
[TD]ABS Luxury Wheels[/TD]
[/TR]
[TR]
[TD]ACTAUT[/TD]
[TD]Action Autosports[/TD]
[TD][/TD]
[TD]Action Autosports[/TD]
[/TR]
[TR]
[TD]ACTTIR[/TD]
[TD]Action Tires Specials[/TD]
[TD][/TD]
[TD]Action Tires Specials[/TD]
[/TR]
[TR]
[TD]ADDWHE[/TD]
[TD]ADDS Wheels[/TD]
[TD][/TD]
[TD]ADDS Wheels[/TD]
[/TR]
</tbody>[/TABLE]

 

[Mackers]

If(b2=d2, a2, "")