If cell contains return value

[tharikcse]

Dear All,

Good Day.


I need to return value in RESULT(E) which if CAT NUMBER 1(B) equals to SEARCH in CAT NUMBER 2(C:C) and needs to return respective cell in D ,

For example, IF B2=search(C:C) return value from D
here the results for E2 is need to come SUCCESS

PLEASE HELP ...

S.NO A	CAT NUMBER 1 B	CAT NUMBER 2 C	DESCRIPTION D	RESULT E
1	882-014-22	852-562-23	BOWL	SUCCESS
2	456-879-12	801-403-00	CITRIC
3	167-301-00	123-526-00	SPEED
4	164-650-00	456-879-12	FAN
...
...
99	456-879-12	882-014-22	SUCCESS
100	852-562-23	167-301-00	DEAR

<tbody>
</tbody>

THANKS IN ANTICIPATION

 

[steve the fish]

Try this:

=VLOOKUP(B2,C:D,2,0)

 

[tharikcse]

Try this:

=VLOOKUP(B2,C:D,2,0)

THANKS Its worked...