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 ...
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?
ThanksTry
=IFERROR(VLOOKUP(U11, $AA$4:$AB$20, 2, FALSE), "")
or
=XLOOKUP(U11, $AA$5:$AA$20, $AB$5:$AB$20, "")
The $ signs make the references to ranges in columns AA and AB absolute, i.e. they don't change when you fill or copy down.
