macro to compare value against multiple ranges and enter value based on that

You would construct a two-column Lookup table. The first column is the beginning of the range wherein you'd want one result, and the second column is the result you'd want. The next row shows the beginning of the next tier and next result, and so on. For example, in columns M:N you might construct this table:

Please Login or Register  to view this content.

Then perhaps in F3 you had entered the number 2.5 and wanted the code "C" to appear in F4, the lookup formula would be:

=VLOOKUP(F3, M:N, 2, 1)


The answer is "C" because 2.5 falls in the "2" tier, before the start of the "4" tier.

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.