Please bear with me while I'm new to VBA / Macros...
I am using VLOOKUP to lookup value ("Worksheet Criteria") from another worksheet ("Criteria Lookup"). I would like to match the source formatting (or at least the cell color).
I have tried several codes I found in forums, but I can't get it to work. I either get #value! or #name? errors.
Can anyone help?
Thanks in advance!!