Hopefully a simple fix but can't for the life of me figure it out.
If I enter a number in Column F (any cell, lets say F10 for this example), I would like it to check the corresponding cell in Column A i.e. A10 for a value.
If the cell is empty in A10, it removes the value the user has entered into F10 with the message "Missing corresponding item No in Column A. Costs can only be entered alongside an Item No".
I have tried the following but to no avail. I get the message regardless of if the condition is met or not, any column I type in etc.
Hoping someone can help.
Many Thanks Steve
Please Login or Register to view this content.