Hi,
I do have a worksheet with a list of a lot of account numbers, like this:
What I want to do, is to automatically insert a value in the D column, based on the account number (column A).
The mapping should be done using this layout:
Where the value I want to insert (in column D in first image) should be between one of the ranges (in column A and B), and then return the value in column C.
I need to have both from and to-value, as there might be some open gaps in the mapping scheme.
How should the formula be?![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I do have a worksheet with a list of a lot of account numbers, like this:
![295wacw.jpg](/board/proxy.php?image=http%3A%2F%2Fi67.tinypic.com%2F295wacw.jpg&hash=46f4b1556071524ae4d7a79614ae2830)
What I want to do, is to automatically insert a value in the D column, based on the account number (column A).
The mapping should be done using this layout:
![1zx15sl.jpg](/board/proxy.php?image=http%3A%2F%2Fi68.tinypic.com%2F1zx15sl.jpg&hash=835c2339635f76abee44f62214b82e85)
Where the value I want to insert (in column D in first image) should be between one of the ranges (in column A and B), and then return the value in column C.
I need to have both from and to-value, as there might be some open gaps in the mapping scheme.
How should the formula be?