Vlookup with cell background color

Dear All,

Please help me out or suggest me how to vlookup with cell backgrond color, eg. i have sheet1 & 1000 names in column A and i want to vlookup columnB values with multiple cell colors (with formatting) in sheet2 ColumnB according to columnA. please suggest me any shortcut or vlookup formula for V-looking up with cell background colors.

NOTE: I have matched names in Sheet1 & Sheet2 in ColumnA.

Thankyou All.

And explain what you wish to achieve, I am not sure if you mean. Perhaps attach a spreadsheet with the desired outcome shown manually, as per the instructions in the yellow banner

The lookup matches the cell value and the cell colour

or

the lookup needs to return the cell colour as well as the value

It can be done with VBA code, but is a painful process, and a potential for error, as colours only need to be slightly out not to match, although they may look to be exactly the same. I echo Ford's comments

Dear davsth,

Please find attached sample file.

the lookup needs to return the cell colour as well as the value.

Have a look at this
https://www.extendoffice.com/documen...urn-color.html

It seems to be what you want

davsth,

thanks, but it's only working in same sheet, however we have two different sheets (sheet1 & sheet2) & we want to vlookup in two different sheets.

is there anything you can manipulate code accordingly.

Thanks.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Dear All,

Please find below cross posting link,

https://www.mrexcel.com/board/thread.../#post-5627852

Thanks.