Hi
I have a spreadsheet (see attached) I want to be able to insert a number (from 1-5, which will represent how many inspections someone has completed in that week) in the cells coloured blue and depending on that value have the cell populate with one of the cells in column R.
For example if I enter:
1 = R4
2 = R5
3 = R6
4 = R7
5 = R8
As for the purpose of this spreadsheet the ticks better diplay the data.
Is there a formula that is able to do this?? (I would prefer a formula as I do not know how to use macros and I will need to take the formula from the spreadsheet I have provided onto the original copy.)
Any help would be greatly appreciated![]()
Bookmarks