Tip #188_Excel

Excel (Advanced): vLookup to Return a Function Result

 

Those familiar with VLookup know that they are a handy way to look for one value (or name) and return the corresponding value in a table. But what if you want the result of a function – instead of the lookup value?

 

Full tip: Excel tip