Look up table

I have some test data of electrical current measurements. For every measurement i would like to compare it against certain ranges of current. if it falls within one of these ranges then i would like to add the name of the range to the data.

for example i have various ranges of current which are labelled. the first range C1 is between 7 and 69, range 2 is C2 and is between 78 to 105...... i wouild like to systematically go through my column of data and if the value is 45 it would put C1 in the next column. i would then cylcle through each row of data and check against my ranges.


This all needs to be created in VBA, i did have an attempt at it but it was getting very clunky with IF statements, i was also strugling to systematically go though each row of data and perform the comparasion.

any help would be appreciated. i have atatched a subset of data (the real data will have 50,000 entries)

Claire

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M