Vlookup help

[ubaps]

Hello All,

I'm trying to work on a formula regarding vlookup.

there are basically 3 column.

Column A's data corresponds to the data in column B. (basically, they are partners)

I need to find (using vlookup) the values from Column C that are in Column A together with Column B.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]3
[/TD]
[TD]Orange
[/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD]5
[/TD]
[TD]Banana
[/TD]
[/TR]
[TR]
[TD]Banana
[/TD]
[TD]3
[/TD]
[TD]Apple
[/TD]
[/TR]
</tbody>[/TABLE]

The the formula should be:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[TD]OUTPUT
[/TD]
[TD]OUTPUT
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]3
[/TD]
[TD]Orange
[/TD]
[TD]Orange
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD]5
[/TD]
[TD]Banana
[/TD]
[TD]Banana
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Banana
[/TD]
[TD]3
[/TD]
[TD]Apple
[/TD]
[TD]Apple
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]

Apologies for my bad explanation in English.

 

[Beyond_avarice]

Column "D":

=VLOOKUP(A2,$A$2:$C$4,3,FALSE)

Column "E":

=VLOOKUP(D2,$A$2:$B$4,2,FALSE)

 

[Aladin Akyurek]

In d2 enter and copy down:

=$c2

In e2 enter and copy down:

=vlookup($c2,$a:$b,2,0)

 

[ubaps]

Worked like a charm, I was thinking of compressing into 1 long formula. Thanks Beyond_avarice.

 

[ubaps]

Thank you very much!

 

[Aladin Akyurek]

You are welcome.