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.

Column A	Column B	Column C
Apple	3	Orange
Orange	5	Banana
Banana	3	Apple

<tbody>
</tbody>

The the formula should be:

Column A	Column B	Column C	OUTPUT	OUTPUT
Apple	3	Orange	Orange	5
Orange	5	Banana	Banana	3
Banana	3	Apple	Apple	3

<tbody>
</tbody>

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.