aryanaveen
Board Regular
- Joined
- Jan 5, 2015
- Messages
- 104
Hi All
Can someone please help me.
in below table Column D is data validated only to have "won" or "fail" , I need a vlookup formula in column D which will look status of column A in column C and if it should result if it is Won or failed, if there is any other value other than won or fail it should remain blank( as column D is data validated it will not allow any other vaues)
A B C D
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
Can someone please help me.
in below table Column D is data validated only to have "won" or "fail" , I need a vlookup formula in column D which will look status of column A in column C and if it should result if it is Won or failed, if there is any other value other than won or fail it should remain blank( as column D is data validated it will not allow any other vaues)
A B C D
Data | sales | status | won/fail | |
abc | 1000 | won | ||
def | 300 | unknown | ||
ghi | 250 | fail |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>