Tag: xlookup
-
Mastering XLOOKUP: The Ultimate Lookup Function for Scientists and Engineers
Oftentimes, data is stored in tables and frequently needs to be accessed. Take, for example, this data set (taken from kaggle.com) that lists the refractive indices of glass as a function of the percentage of the various elements present in it. Imagine needing to quickly look up the elements of a glass with a particular…