LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 206
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation question Lost Excel Discussion (Misc queries) 1 June 2nd 09 08:39 AM
Data Validation Question DonkeyKong Excel Discussion (Misc queries) 4 December 29th 08 07:10 PM
Data Validation Question jwags Excel Discussion (Misc queries) 1 August 18th 08 06:23 PM
Data validation question Tom Excel Programming 2 October 2nd 04 01:50 AM
Data Validation Question Kenny Excel Programming 2 November 11th 03 05:28 AM


All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"