Drewmyster
Board Regular
- Joined
- May 16, 2007
- Messages
- 150
- Office Version
- 365
- Platform
- Windows
Hard to explain but the requirement is that if A1:A5 contains any value (only one cell will contain a value at any one time), then look up and return the value of the cell two rows below that value.
For example, If A3 contains the number 5, then look up C3 which contains the word "Month" and return the text string there.
Also
If A2 contains the number 2, then look up C2 which contains the word "Week" and return that word.
Any help appreciated.
For example, If A3 contains the number 5, then look up C3 which contains the word "Month" and return the text string there.
Also
If A2 contains the number 2, then look up C2 which contains the word "Week" and return that word.
Any help appreciated.