Archive for December, 2022

Hi everyone…

Let me start by wishing you all a very happy holiday season and stellar start to 2023. Here is our annual holiday card.

[pictured left to right: Nishanth (son), Jo (wife), Nakshu (daughter) and Chandoo (me)]

Excel formula to get a match from a given value in excel when you have start and end values in lookup table. This technique is useful for looking up a matching price from a pricing tier table or date in a range of start and end dates.

You open an Excel file and some cells show #### instead of the value. Here is a quick fix.