Column A: List of All Products set as a drop down using Data Validation.
When I select a product from the Data Validation Drop down I would like for it to autogenerate the price of the product into the cell to the right.
I typically use a nested IF function to do this but the product list is 61 items long and you can only go up to I believe 7 nested IF Functions.
Does anybody have an idea on how you can do this?
Bookmarks