Hack #105. Lookup from Within a Cell
Usually, in order to use one of Excel's lookup functions, you are required to lookup from within a table of cells in a worksheet. This hack shows how to perform a lookup on a small number of items, without leaving the cell.
Let's assume you have a changing value in A1 and want to return a result to B1 that...
Excel Hacks - Content Snippet from BJepson
Share this highlighthttp://www.safaribooksonline.com/a/excel-hacks-2nd/4112313/