ANmarS - Portfolio - Clookup

Excel/VBA expert since Sep 1997 (20 years 11 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

Clookup    Added: 1/2/2013 | Created: 1/21/2009   



I have seen a lot of requests asking about a lookup functionality that works for colors, this dated back in 2009 when I had some time to work on it, it is a UDF (User-defined-function) that grap the color for the corresponding number based on a separate table which has the colors needed for each ID in the CLOOKUP.

Here is a video on how to apply it, or you can see it here.


Download (331.6 KB)

1336 downloads | Last updated: 1/15/2014


Screen shots (7)