Excel vlookup data/text and colour? or another formula

[Karoundtheworld]

Hi, I'm using vlookup to find data, but the data is highlighted in different colours and I need this to appear as well as the data/text. Is there a way to do this? The data is individually highlighted with a specific RGB colour for each one and so far could not think of a way to do this. In the end there will be 81 RGB colours and text answers (just in case there is a limit, but if I had to I could break this down to 14 and less for each cell). Hoping someone can help. Thanks for reading

 

[dermie_72]

Two ways that I can see - off the top of my head.
1, if you're using conditional formating to color the cells, then replicate the condition in the new table. This would be the most efficient way to do it.
2, If it's manually colored, then you could do 1 of 2 things.
2.1 Copy paste value the vlookup table. Sort by lookup value
Go to the table with the colors, and add a column to countif the value in the table.
Sort that column, and lookup value.
The tables should match and you can copy paste format
2.2 Use a macro to copy formats from one table to the other once the data is populated.

Hope one of the many options is suitable to your needs.