Excel 2013 - 2 Data Validation Column in Google Sheet Document

[CrystalFacets]

Skip - Per your request, here's a copy of my 2nd inquiry about adding 2nd Data Validation column in Google Sheet document. Thank you.
(Same Excel worksheet attached before upload to Google Sheets.)

---------------------------------

Hello again. In an 'ideal' world is there a way of doing the following 1 or 2 things?

First, could there be a 2nd data validation column to the right of the 1st one that allows the user to input info provided that it's not the same info as the 1st DV? For example, let's say the 1st DV column contains different 'types' of hardware -- light bulbs -- instead of names. We would want the user to input in the 2nd DV the BRAND of light bulbs they purchased. Possible?

Second, several users will have access to this Google Sheet in GMail. In an 'ideal' world, is it possible for each user to only have access to the DV cell(s) next to their name?

I think these are 'pie in the sky ideas' for another day ... thumbsup2

 

[SkipVought]

Hi,

Please explain the purpose of this sheet.

Please upload a sample sheet, not necessarily functional, that displays the columns you need with an expaination for each column.

Functional data would be helpful in these examples.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]