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 ...

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]S.NO
A[/TD]
[TD="align: center"]CAT NUMBER 1
B[/TD]
[TD="align: center"]CAT NUMBER 2
C[/TD]
[TD="align: center"]DESCRIPTION
D[/TD]
[TD="align: center"]RESULT
E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]882-014-22[/TD]
[TD]852-562-23[/TD]
[TD]BOWL[/TD]
[TD]SUCCESS[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]456-879-12[/TD]
[TD]801-403-00[/TD]
[TD]CITRIC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]167-301-00[/TD]
[TD]123-526-00[/TD]
[TD]SPEED[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]164-650-00[/TD]
[TD]456-879-12[/TD]
[TD]FAN[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]99[/TD]
[TD]456-879-12[/TD]
[TD]882-014-22[/TD]
[TD]SUCCESS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]852-562-23[/TD]
[TD]167-301-00[/TD]
[TD]DEAR[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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...