SQLDAXExcelPython
Leaderboard
LookupsMedium20 points

Price bands with approximate match

In a new column of Products, label each UnitPrice (column E): Budget from 0, Standard from 2000, and Premium from 20000. Use LOOKUP with array constants instead of nested IFs. Write the formula for row 2.

How your answer is tested

Your formula goes in a new column of the Products sheet at row 2, and is filled down to the last row.

Show solutionLifetime

Runs in your browser with IronCalc, an open-source spreadsheet engine, so this isn't Microsoft Excel. The questions here were checked against real Excel, but a few functions such as AGGREGATE are not available.

Excel formulaselect text to run only that part
Loading editor…

Press Ctrl+Enter or Run to see the result here.