Forum Discussion
Solved
IFS syntax Question #NAME? error
I created a spreadsheet to collect times & material cost for the sake of updating our pricing in our paint department. I wanted the operators to select the paint of choice from a drop down menu, and ...
Hey Hans
Thanks for the kind effort!
When deploying that formula on my spreadsheet, I get a #NAME? message in the cell. Also, while using your spreadsheet, I get the same message (in the "Cost p/Oz" cell) when selecting a paint type in any of the cells that contain a drop down menu item.
Thanks for the kind effort!
When deploying that formula on my spreadsheet, I get a #NAME? message in the cell. Also, while using your spreadsheet, I get the same message (in the "Cost p/Oz" cell) when selecting a paint type in any of the cells that contain a drop down menu item.
I used XLOOKUP., which is on;y available in Microsoft 365 and Office 2021.
Here is a version using VLOOKUP.