In column H any one of the following values could be inputted:
am
pm
am pm
1
2
3
4
5
6
as they are inputted a value should appear in column I based on the following 'scoring' system:
am=1, pm=1, am pm =2, 1=2, 2=4, 3=6, 4=8, 5=10, 6=10
I tried setting up a VLookup table in another sheet called punishment table to hold these values, the first column starting at A2 and second column starts in B2.
1 2
2 4
3 6
4 8
5 10
6 10
am 1
am pm 2
pm 1
Am I going about this in the right way? Can't seem to get it to return the right value in column I.
am
pm
am pm
1
2
3
4
5
6
as they are inputted a value should appear in column I based on the following 'scoring' system:
am=1, pm=1, am pm =2, 1=2, 2=4, 3=6, 4=8, 5=10, 6=10
I tried setting up a VLookup table in another sheet called punishment table to hold these values, the first column starting at A2 and second column starts in B2.
1 2
2 4
3 6
4 8
5 10
6 10
am 1
am pm 2
pm 1
Am I going about this in the right way? Can't seem to get it to return the right value in column I.