ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   another data validation / ifisblank question (https://www.excelbanter.com/excel-programming/325098-another-data-validation-ifisblank-question.html)

Gixxer_J_97[_2_]

another data validation / ifisblank question
 
what I am trying to do is the following

in column B I have the following formula in rows 10-20 (row 11 would have
$A11, etc)

=IF(ISBLANK($A10),"","Do something")

in column C I have a data validation box that the user can choose something
that refers to this particular line.

is there a way i can incorporate a similar formula so that if A10 is blank,
then don't display any text, and if it is not blank then display the first
value in the validation list so that the user can select?

hopefully this makes sense

thanks!

J


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com