ANmarS - Portfolio - Clookup

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

1350 downloads | Last updated: 1/15/2014

Screen shots (7)