Forum Discussion
IF statement based on multiple columns.
So the geographical context is "Vendor Master"
Logic context is if the vendor # 2 is blank, the system or vendor admin does not promote a vendor 3 to vendor 2 if vendor 2 is blank for some valid reason?
What is the logic behind having alternate vendors? Pricing? Stock availability? Other?
Does the company policy allow the system to have a vendor 3 when vendor 2 is blank?
Why would vendor 1 be blank? when there is vendor 2 and vendor 3?
The only reason each vendor is in a different row is because it is a different company and not the same company in a different location/store
"I have 3 columns for Vendors i.e Vendor 1, Vendor 2, Vendor 3. I want to put up a formula in "Vendor Master" such that IF "Vendor 1" is blank then it should return value from "Vendor 2" in "Master Vendor"." - Gives me the impression that the vendor is the same company in a different location.
What is the basis on the condition that there is "no vendor"?