Check if excel value is available in another column

Question

I've looked at some of the posts but couldn't find much help.

I have a dataset like this

Column A   Column B   Column C 
ABC        ZZZ        123
BBB        ABC        234
ZZZ        BBB        567

I need to write a formula in column D, if ABC is available in column B, enter me the value for column C.

I tried all VLOOKUP features but couldn't find it properly. Can someone please help on the same?

+3

excel

arvind_cool May 05 '17 at 4:03

source to share

2 answers

Column A Column B Column C Column D ABC ZZZ 123 = VLOOKUP (L2, $ M $ 2: $ N $ 4,2,0) BBB ABC 234 567 ZZZ BBB 567 123

0

LalitM 05 May '17 at 7:44

source to share

India.Rocket · Accepted Answer · 2017-05-05T04:06:33+0000

Have you tried this with VLOOKUP in D1

=VLOOKUP(A1,$B$1:$C$3,2,0)

After writing to D1, drag this to the end enter image description here