Match different columns and return a value

Closed
varun - Jan 16, 2012 at 11:06 PM
 Blocked Profile - Jan 16, 2012 at 11:29 PM
Hello,

Hi Guys,

I have a list which looks like this

A B C
2 0
3 3
4 4
67 67
89 14
8 8

What i want to do here is match the two columns A and B if the values are matching then in the C column i want to reflect as DONE, or if it is not matching it should reflect as PENDING. Is that possible????

1 response

Blocked Profile
Jan 16, 2012 at 11:29 PM
Greetings,

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator
0