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 ...
<tbody>
</tbody>
THANKS IN ANTICIPATION
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