Set one number to equal another

[Silkygee]

Hi,

I have a preset series of values that I want to equal other values. For example:

5.00 = 135
5.02 = 136
5.04 = 137
5.07 = 138
5.09 = 139
...
6.00 = 180

Can I get excel to run down approx 7000 rows checking for a possible of 360 numbers in each cell, then converting that number to its corresponding value as above?

For example if the value in cell A1 was 5.02, B1 would equal 136. The problem is A1 may contain 360 different values and I need excel to convert it to the corresponding value.

Any help is greatly appreciated. Thanks in advance.

[TMS]

Have a look at the VLOOKUP function.

Regards, TMS

[Domski]

Easiest way would be to set up a look up table and then use VLOOKUP to populate the corresponding value.

Dom

[bebo021999]

Upload a sample file to get it solved