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

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>

 

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