If you have worked with spreadsheets a bit, you must have encountered lookup functions. The most common one is the VLOOKUP, which can be used to couple two tables: What not everyone knows it that you can use LOOKUPs in another way as well, to classify data. That looks as follows: By default, Excel (and […]
