I have an excel sheet with rows of data. For every row I want to display an image depending on some condition in this row.
Numerous tutorials can be found on how to show one Image based on some condition by creating a name, and adding some INDEX function with a SEARCH function. But in this function a relative offset of some kind seems not to work (e.g. https://stackoverflow.com/questions/507253/excel-formula-to-reference-cell-to-the-left).
Is it possible to create a image lookup depending on some condition in the row for a number of rows without defining a name for each rows image?