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 ...
As SergeiBaklan pointed out, the name strings have to be in quotes. An alternative strategy often used in similar situations is to exploit the validation list to look up data from a corresponding list of data (cost in this case).
= XLOOKUP(selectedPaint,PaintColors,Cost)
Interesting Peter
I like that idea. I'm new to some of these formulas but I should be able to figure that out somehow. the current table I created for my spreadsheet looks like this which I think is a great candidate for your suggestion:
Paint Types Costs p/Oz.
Primer Yellow $1.07
Primer Green $1.05
Primer Grey $1.22
Primer Black $1.15
Topcoat White $1.56
Topcoat Grey $1.61
I like that idea. I'm new to some of these formulas but I should be able to figure that out somehow. the current table I created for my spreadsheet looks like this which I think is a great candidate for your suggestion:
Paint Types Costs p/Oz.
Primer Yellow $1.07
Primer Green $1.05
Primer Grey $1.22
Primer Black $1.15
Topcoat White $1.56
Topcoat Grey $1.61
A demonstration.
Thank you Peter. I'll read up on "lookup" & "vlookup" to see how it's used.
- Hi
I created a long IFS formula, i.e.: "=IFS(U11=AA5,AB5,U11=AA6,AB6,U11=AA7,AB7,U11=AA8,AB8,U11=AA9,AB9,U11=AA10,AB10,U11=AA11,AB11,U11=AA12,AB12,U11=AA13,AB13,U11=AA14,AB14,U11=AA15,AB15,U11=AA16,AB16,U11=AA17,AB17,U11=AA18,AB18,U11=AA19,AB19,U11=AA20,AB20)."
How can I paste it in various, non-sequential fields on my spreadsheet with out getting the table data locations skewed?
Thanks