Hi,

I'm trying to create an if statement that whenever the user selects
"Debit Memo" from the dropdown menu in column A (has other items--
Credit Memo Check, Transfer), the user would be forced to enter the
corresponding value in column F (Debit). If the user attempts to
enter the value in Column G (Credit)column, an error message would be
generated "Incorrect Account".

Grateful for any assistance in resolving this matter.


WC

One way:

Select your cells in Column G (say, G2:G100, with G2 the active cell).
Choose Data/Validation, and enter

Allow: Custom
Formula: =$B2="Credit Memo"

Uncheck the Ignore Blanks checkbox. Similarly, in column F, use

=$B2="Debit Memo"

If more than one value in column B is acceptable for a column G entry,
use OR(), e.g.:

=OR($B2="Credit Memo",$B2="Transfer")

In article <(E-Mail Removed)>,
(E-Mail Removed) wrote:

> Hi,
>
> I'm trying to create an if statement that whenever the user selects
> "Debit Memo" from the dropdown menu in column A (has other items--
> Credit Memo Check, Transfer), the user would be forced to enter the
> corresponding value in column F (Debit). If the user attempts to
> enter the value in Column G (Credit)column, an error message would be
> generated "Incorrect Account".
>
> Grateful for any assistance in resolving this matter.
>
>
> WC