Mappimg one set of numbers to another
Posted by Brian on January 28, 2002 12:07 PM
I have a column of numbers (columnA).
They range in value from 1-40.
I want to change these using a 2x40 reference array (columnE&F) (E1 maps to F1, E2 to F2 and so on to E40 to F40),to produce another column (B) with some type of lookup or logical command.
So if A1 contains 28 for example then the mapping in the matrix at E28 will correspond to the value say 7 in F28.
Then in B1 number 7 will appear. And so on down the list.
How can I achieve this?
PS Thankyou to Ivan M. for assistance previously today.