Check if a cell from the same row but different column is empty

**Stephen Troughton** · 04-27-2018, 06:16 AM

Hi,

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.

**AlphaFrog** · 04-27-2018, 06:50 AM

You could do this using the Data Validation feature on the Data menu.

Select F1:F5000
Select Data\Data Validation
- Allow: Custom
- Formula: =A1<>""
- Configure your message on the Error Alert tab
- Okay

**Stephen Troughton** · 04-27-2018, 07:22 AM

Hi,

Have followed exactly what you suggested and this doesn't work. The message appears regardless if there are entries in both columns, no entries, one in one column and not the other and so on.

To be more clear sorry, even if there is a value on column A, its stops me from putting a value in Column F, which is shouldn't. Only if there is no value in the same row number in Column A should it stop me putting a value in Column F.

Cheers
Steve

**AlphaFrog** · 04-27-2018, 07:52 AM

Originally Posted by Stephen Troughton

Hi,

Have followed exactly what you suggested and this doesn't work. The message appears regardless if there are entries in both columns, no entries, one in one column and not the other and so on.

To be more clear sorry, even if there is a value on column A, its stops me from putting a value in Column F, which is shouldn't. Only if there is no value in the same row number in Column A should it stop me putting a value in Column F.

Cheers
Steve

I've tried it and it worked for me. So something is different.

If you selected F1:F5000 by dragging from the bottom up and the active cell was F5000 when you applied the DV formula, then the DV formula doesn't apply properly. Try selecting all of Column F with F1 being the active cell and then re-apply the Data Validation as before.

**Stephen Troughton** · 04-27-2018, 08:04 AM

Hi,

Works fine now, thank you so much.

Regards Steve

Check if a cell from the same row but different column is empty

LinkBack

Thread Tools

Rate This Thread

Display

Check if a cell from the same row but different column is empty

Re: Check if a cell from the same row but different column is empty

Re: Check if a cell from the same row but different column is empty

Re: Check if a cell from the same row but different column is empty

Re: Check if a cell from the same row but different column is empty

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check if value is in range, and if so check cell on row empty

[SOLVED] want to check for empty cell with vba

[SOLVED] Paste formula to the last empty cell based on a non-empty cell on another column

Find Empty Cell Check Next Column For a Value

[SOLVED] How to check for an empty cell

check 1st empty cell then delete column

check a cell is empty or not

Bookmarks

Bookmarks

Posting Permissions