Good morning / good evening all.
I was wonder if its possible to have a cell with a IF formula so a value based off a dropdown in another cell when selected. For example in A1 i have my dropdown with some names and when i select a certain name A2,A3 and so on would auto fill with the preset name in the formula that matches the name in the drop down. See images for example. And here is the formula that i tried
=IF($AV1="Amazon", "Caledonia", IF($AV1=iPatio, "Calendonia", if($AV1=Shopify, "Calendonia", if($AV1=Walmart, "Buford", if($AV1=Houzz, "Norwich", If($AV1=Wayfair, "Brampton", if($AV1=Overstock, "Marieville", if($AV1=Sams Club, "Hudson", if($AV1=Home Depot of Canada"",)))))))))
dropdown.JPG
Thanks for the time and tips,
Erick
Bookmarks