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 From https://www.safaribooksonline.com/library/view/excel-hacks-2nd/9780596528348/ch06.html#lookup_from_within_a_cell: