Hi. Is there a way to use VLOOKUP to lookup and return both the values
from one list to another as well as the cell fill color of the source
list?

My users have a main workbook that imports updated data to a temporary
sheet. Below shows the general layout of the temporary sheet, with
DOC being the key. I've already got a macro that copies the DOC, RAT,
and Notes from the main workbook and imports the new DOC numbers from
the external workbook. And the macro adds a VLOOKUP formula to the
second RAT and NOTES columns. The macro then copies/pastes the
updated DOC, RAT, and Notes columns back to the main workbook. And it
works well.

BUT, users add personal color coding to their DOC, RAT, and Notes
cells, and it's important to be able to carry over the color coding
with the value that's looked up.

Example sheet layout:

DOC RAT Notes DOC RAT Notes

Is that possible? Thanks!

Frank