Find matching value in A and return same row value in B

[DeleriousX]

Hello!
This is my sheet

 5    216     5
 8    380     5
10    395     5
12    400    10
13    410    10
20    500    12
22    502    20
             20
             20

This is the output I need

5    216     5     216
8    380     5     216
10    395     5     216
12    400    10     395
13    410    10     395
20    500    12     400
22    502    20     500
             20     500
             20     500

So basically take the value in C and look it up in A and return the matching value from B

I have tried Vlookup, but it will only return a value from the first of duplicate listing in C.
I have searched for the vlookup duplicate issue, but haven't found any solution I could get to work for my scenario.

Anyone know how to handle this?

 

[NARAYANK991]

Hi ,

From what you have posted , VLOOKUP should work just fine.

=VLOOKUP(C2,A$2:B$8,2,FALSE)

should work. Enter this in D2 and copy down.

Narayan

 

[DeleriousX]

It did work. Thanks!!
Not sure why it didn't come out right before.