Message box with an IF statement

Question

Hello,

I am trying to figure out the best way to make this work.

I would like to Popup a Message that will alert the user about entering a Job Number.

For example:

If Expense Type starts with Job, then a Message Box "Please Enter Job Number"

Or if the user navigates to Column F (Purpose) to not to let the him continue unless they enter a Job Number if the Expense Type starts with "Job"

Your help will be greatly appreciated.

Answer 1

Hi julietajb,

Greetings! Thank you for posting to Microsoft Community.

You can use data validation to get a message box.

Select F3:F10. Data>Data Validation

Uncheck Ignore Blank, select custom, Input formula.

=IF(COUNTIF(D3,"*job*")>0,LEN(E3)>0,TRUE)

Then you can set custom message for it.

Best Regards,

Snow Lu

Answer 2

Thank you so much Snow Lu!!! it worked!

I did the data validation for the first row and just drag it down to the rest of the rows in the spreadsheet.