How to Fix Windows Update Errors?: How to Fix Error

Monday, September 26, 2016

Dependent Data valadation

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.

Anwsers to the Problem Dependent Data valadation

Download Error Fixer (Free)

Make Sure that your System Meets the System Requirements

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your computer hardware is not up to par, then make sure you upgrade where necessary before continuing.

Another Safe way to Fix the Problem: Dependent Data valadation:

How to Fix Dependent Data valadation with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.