Is there any way to lookup if a specific value is found left of my current cell (or another given cell)? I only need to look in one row, not several.
I would like to use this to decide which cell my current cell should retrieve data from. If the specific value (eg. 12) is found left of mye current cell I would like it to read from D2, if not read from C2.
Or, any way to lookup and return the cell reference to where a specific value is found (only one row)?!
Bookmarks