ANmarS - Portfolio - Clookup

Excel/VBA expert since Sep 1997 (19 years 11 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)

1293 downloads | Last updated: 1/15/2014

Screen shots (7)