Vlookup - copy column formatting and values

[zainali]

Hi everyone,

I got two excel workbooks -
Excelworkbook1 - contains employee details


EMPID, EMPPosition, EMPName

1 Analyst Derrek
2 Programmer John
3 Technician Broad



Excelworkbook2 -

empid, empposition, empname

Derrek
John
Broad


My question: I want to pull emPID,empposition from Excelworkbook1 using vlookup, which works fine, the interesting part is I want to get column formatting i.e, color along with the values of the columns from Excelworkbook1.

Please can someone help?

Many thanks

[dilipandey]

Hi Zainali


welcome to the forum.

would suggest you to copy entire column from excelworkbook1 and paste special formats in excelworkbook2 and you'll have column formatting in one go.. after this you can always get the required values as per your loookup function.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>