HLookup w/ Source Formatting Preserved

[excelgod123]

Hello,

I am working on a project which requires me to use the HLookup function to reference data from Sheet 1 and transfer it into Sheet 2. The data in Sheet 1 is color coded and the cells have a color fill on them according to certain criteria. I am looking to preserve this information after the HLookup is executed and want the information in Sheet 2 to have the same formatting. Unfortunately, I cannot use conditional formatting on this job.

Any help would be appreciated, and I don't mind Macros or VBA as long as the instructions are straight forward. If you know of another function that can achieve this functionality, I don't mind exploring that path either. I have attached a simplified version of my sheet to this thread.

Thanks!

Hi all, this has been solved using Vlookup.

[63falcondude]

Hello and welcome to the forum.

the cells have a color fill on them according to certain criteria

I cannot use conditional formatting on this job

Why not? If the fill color follows some sort of logic/criteria, you should be able to implement that into a CF formula.

[excelgod123]

Think of it this way. The data (job name) is filled according to the person on the job. This is often changing as there's different people handling the job on different days. I would like the system to be dynamic, so I don't want to make a list and then go into conditional formatting because that will cause problems when people are removed/added.