PC Review


Reply
Thread Tools Rate Thread

Dependent Data Valadiation

 
 
willwonka
Guest
Posts: n/a
 
      3rd Aug 2010
I'm having some Validation Issues.

Here is my Validation formula:

=IF(ISBLANK(B5),INDIRECT("entities"),INDIRECT(VLOOKUP(B4,acctlookup,
2,0)))

The Validation Lists works right; but it also is accepting anything
when I type directly into cell.

So first, I tried:

=entities (and that worked perfectly)

Then

=Indirect("entities") (and that worked perfectly)

but when I add the If statment, it starts allowing me to put anything
into the cell; but yet the dropdown list works as planned. It just
doesn't seem to validate anymore.

Any thoughts?

PS... I don't think we need to worry about 2nd part of the formula as
I don't think that is the problem. It just seems to be the "IF" thing
that is causing the problem. I say this because I change the if
formula to look like this:

=IF(ISBLANK(B5),INDIRECT("entities"),INDIRECT("accounts")) and still
go the error.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dependent Data Validation Shacks Microsoft Excel Misc 3 12th Aug 2009 06:58 PM
input data dependent on other cells confused deejay Microsoft Excel Worksheet Functions 4 16th Oct 2008 02:56 AM
Conditions, dependent data ineedhelp Microsoft Access 4 12th Jun 2008 10:42 AM
dependent lists on data validation =?Utf-8?B?Q2hyaXM=?= Microsoft Excel Misc 3 8th Nov 2007 12:03 AM
Field dependent on another won't keep the data Jacques Microsoft Access Forms 0 19th May 2006 01:08 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:25 PM.