I like it when formulas are shorter and less complicated. thanks Paul
@didi55262 ай бұрын
But not dynamic.
@khalil5472 ай бұрын
Super! How excel is easy with you! Thumbs up 👍
@ExcelU2 ай бұрын
Thank you 🤗
@RogerStocker2 ай бұрын
How about =CHOOSE()?
@markperrah1862 ай бұрын
Nice work Jeff. Even easier to write the formula when you name the ranges. CategoryRng and RateRng and the Price cell as PriceVal. turns into: =XLOOKUP(D2,CategoryRng,RateRng)*PriceVal