Add a new value based on adjacent value
Posted on 2014-12-22
The lookup values are cube numbers produced by checking against other values in the spreadsheet and are part of one of the following 4 groups (A1, A2, A3, A4) where A represents an area and C represents a cube number.
C1-C280 - member of area 4
C282-C448 - member of area 3
C454-C648 - member of area 2
C659-C894 - member of area 1
The lookup values (cube numbers) are in column W, and I need area numbers to fill for column V once a cube number exists in column W. If a cube number does not yet exist in column W, then I want for nothing to occur in column V.
Assistance is greatly appreciated.