Match values

[hsandeep]

I am giving straight example, please bear with me:
W16=XYZ (alphanumerical, numerical or alphabets). J column, J17:J900, contains values (alphanumerical, numerical or alphabets).
In column W, W17:W900, I want W17=V17 provided V17 contains values (BUT not #N/A or null or blank or even special characters like"-", etc.) AND J17=$W$16.

Please how to accomplish?

 

[narendra]

I am not sure what you want to do with J17 here.
I just want to make sure I am getting it right.

BTW. when you say special characters, are you referring to all the 32 spl characters from the keyboard as given below:
~`!@#$%^&*()_-+={[]}|\:;"'<>,.?/
Also when you said: "null" or "blank". Are you trying to say that there me be a cell which is not blank but, has "null" value?
like, having the following formula in a cell: =""

 

[hsandeep]

For filling W17 as equal to the V17 provided V17 contains values (BUT not #N/A or null or blank or even special characters like"-", etc.) AND
J17=$W$16. So these 2 conditions MUST MATCH, thats why J17.
BTW. when you say special characters, are you referring to all the 32 spl characters from the keyboard as given below:
~`!@#$%^&*()_-+={[]}|\:;"'<>,.?/ YES YES

Also when you said: "null" or "blank". Are you trying to say that there me be a cell which is not blank but, has "null" value?
like, having the following formula in a cell: ="" YES YES

 

[hsandeep]

Narendra,
Please help.
Thanks in adv