LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Validation with formulas

I use to think I knowe a lot about Excel - but as people ask "can you do
this?" I dont know as much as I though

In the valiation source - can a formula be entered

i.e.

=($E4="Books","NA",=INDIRECT($E4))

Becky
 
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 formulas Peter Excel Discussion (Misc queries) 1 March 21st 08 02:24 PM
formulas/data validation CHRIS...in trouble Excel Worksheet Functions 1 December 30th 07 01:33 PM
Data Validation formulas Lele Excel Discussion (Misc queries) 4 March 4th 07 02:10 PM
How to use validation formulas in Combobox GlenC Excel Discussion (Misc queries) 1 September 21st 06 10:19 PM
validation formulas Larry Excel Worksheet Functions 4 April 15th 05 03:09 PM


All times are GMT +1. The time now is 01:17 AM.

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

About Us

"It's about Microsoft Excel"