Data Validation

[Johno58jj]

Hi Everyone,

Just joined the form and looking for some assistance as I'm just getting into excel.

I've have Office 365....

I'm working on a rather large spreadsheet and have sorted most of the issues out except one.

Here's the scenario, when the user types in a specific number into a cell a vlookup rule is applied and - in another cell I've set up a true / false formula as follows:
=IF(L3=AW3,"True","False")

I can't figure out how to apply a data validation to the column that if 'false' comes up then the get a pop up to say that number is invalid. I've tried a number of things but can't seem to get it to work...
I'd appreciate any help...

Cheers,
John

[Glenn Kennedy]

Try =L3=AW3 as your DV formula.

[Johno58jj]

tried it as custom - then added formula but didn't work...

[Aardigspook]

Welcome to the forum.

I don't know why Glenn's formula doesn't work for you - it works for me. However, here's another option.
(I assume you want the number entered in L3 to match the number in AW3 - if it's the other way round, amend the cell references below appropriately.)

DV
In the Data Validation for L3 set Allow to List. De-select In-cell dropdown. In Source enter =AW3.

Pop-up Error Message
Go to the Error Alert tab. Ensure Stop is selected for Style. Enter the Title and Error message you want (e.g. Invalid Number and The number entered must match AW3).
You could also enter an Input Message which pops up instructions when the cell is selected.

Hope that helps.

[Glenn Kennedy]

I think we need to see a sample sheet, showing clearly what you are trying to do.

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).



Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[Johno58jj]

Hi
Thanks for your reply, yes now it's working...

Thanks again...

Cheers,,
John

[Aardigspook]

Glad we could help.
As you're a new member, you may not know that you can mark the thread as Solved if your original question has been taken care of so others know there's an answer here. Instructions to do it are in my sig - if you could take a moment to do it, that would be appreciated. Thanks.