vlookup formula in data validation cell

[aryanaveen]

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
[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Data[/TD]
[TD="width: 64"]sales[/TD]
[TD="width: 64"]status[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]won/fail[/TD]
[/TR]
[TR]
[TD]abc[/TD]
[TD]1000[/TD]
[TD]won[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]def[/TD]
[TD]300[/TD]
[TD]unknown[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ghi[/TD]
[TD]250[/TD]
[TD]fail[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[philwojo]

What are you trying to lookup, that isn't clear to me. As of now you could just do an If statement on column-C to populate Column-D.

If you are trying to lookup something from a specific input cell that could be in column-A that is fine, but I'm not sure I"m following you right now.