Data validation

[Mohandas]

Dear Sir,

I want to do validation

I have 3 sheets

1 RM
2 PM
3 FM

I want to do data validation on F column in FM SHeet where i have enter the quantity which has to check in PM sheets whether it has quantity or not ,If not it has to give the message

Please help

 

[Khalid NGO]

Hi,

Try the following steps:

Select your cell F5 till the last cell you want to do Data Validation.
Go to Data > Data Validation
Setting tab > Select Custom, and enter the following formula:
=VLOOKUP(E5,PM!$B$4:$C$100,2,0)<>0

Error Alert tab > Error Message:
Qty is Zero (or any message)
Click Ok

Note: It will work only when the value change in Column F.

Regards,