Recode data?

L

Lars Østergaard

Hi

I have to recode a column of numbers to other numbers. Is it possible

eg. 30 = 500
20 = 60
30 = 800
and so o

I have tried the IF , but you can only use it 8 times in a function

Thanks
Lars Østergaar
 
F

Frank Kabel

Hi
use a lookup table with your transformation rules (col. a the old one,
col. B the new one) and use VLOOKUP. e.g.
=VLOOKUP(A1,'lookup_table'!A1:B100,2,0)
 
P

Peo Sjoblom

Look at the LOOKUP functions although what you post doesn't make any sense
Why are you using different values for the same number (30)?

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top