Hi
I want to lookup a word (e.g. Bananas) and return the value which is one cell above the cell which contains Bananas.
The "Bananas" cell can appear anywhere in columns A:R and the row and column number which contains "Bananas" can change each day i.e the range is dynamic.
Can someone please advise how to do this?
Thanks in advance
Bookmarks