ANmarS - Portfolio - Clookup

Excel/VBA expert since Sep 1997 (19 years 6 months)

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)

1279 downloads | Last updated: 1/15/2014


Screen shots (7)