Recode data?

[Guest]

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

 

[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)

 

[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