O'Reilly logo
  • Tara Feld thinks this is interesting:

Hack #105. Lookup from Within a Cell

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...

From

Cover of Excel Hacks, 2nd Edition

Note

Excel Hacks - Content Snippet from BJepson
From https://www.safaribooksonline.com/library/view/excel-hacks-2nd/9780596528348/ch06.html#lookup_from_within_a_cell: