hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,215
- Office Version
- 2010
- Platform
- Windows
- Mobile
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?
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?