Hi Everyone
I need to change the column from where values are picked up based on the month number, i.e. in month 2 use colum C, month 3 use column D etc. I can't use IF because there are more than 7 arguments but think I might be able to used a nested INDEX / MATCH and VLOOKUP formula and the VLOOKUP bit is where I'm struggling!
The basic information comes from a report which is run each month. This information is then compared to the manual records held for this data.
I have attached an example spreadsheet to make things clearer.
Thanks
Bookmarks