Hey everyone,
I have a huge xls sheet with about 2,000 terms and rankings.. of which I need to pull about 100. I have successfully set vlookup to retrieve these, however on the document I'm pulling from, there are background colors for said cells. Is there any way for Excel to return the background color along with the data on the new sheet?
Thanks a bunch!
--Russell
Bookmarks