Hello,

I came across an interesting VBA code in a website regarding How To Vlookup And Return Background Color Along With The Lookup Value. You can google it to see the website.

I wonder is it possible to do it with sumifs formula?