Lookup for colors in Excel


Add to Cart
Similar to VLookup and HLookup, except this one searches for a matching color

Jan 2009
Internal ID:
77394 (type1)
1 File Tools
Quick tools. Tools that are in 1 file
VBA - Excel
Macros, or Visual Basic for Application tool
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 not a UDF (User-defined-function), but has the look of a function, it graps 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.