Excel VLookup and bringing Font Color

[Jyotirmaya]

I am using Excel VLookup function, but with the function I am getting the values only not the Font color of the cell from which the value is coming out. How to solve the issue ??

 

[DaveBlakeMAAT]

VLOOKUP will only retrieve the value not formats & as such the outputted data is formatted as per the format of the cell that the VLOOKUP function is in.

You could try getting around this using conditional formatting.

Regards

Dave

 

[Michael M]

You can't return font color with a formula
You will need to do it with VBA, or possibly Conditional Formatting

 

[Jyotirmaya]

Conditional formatting will not work, as I have a sheet where there are 1000+ rows are there. and values are of different, conditional formatting will not work. Index Match or Colorindex will not work ?

 

[Michael M]

Ok, in that case you will need to use VBA.

AND

you will need to provide much more detail if you want us to assist further !

 

[Jyotirmaya]

Ok, in that case you will need to use VBA.

AND

you will need to provide much more detail if you want us to assist further !

In the Sheet name called M I need the data to be coped from the sheet named DCBMCOPY

From L6 to AF6 I need to copy data from Sheet DCBMCOPY based on the value of C6.

Presently I am using formula
L6==VLOOKUP($C6,DCBMCOPY!$A1:$V146,2,FALSE)
M6=VLOOKUP($C6,DCBMCOPY!$A1:$V146,3,FALSE)
.... & so on
AF6=VLOOKUP($C6,DCBMCOPY!$A1:$V146,22,FALSE)

& so on upto AF6 but with this I am not able to get the font color of the Vertically looked data.

I need the data to be copied from L6 to AF6 upto L25 to AF25 ( I have formula in L26 & L27)
Again from L28 to AF28 to L47 to AF47 ( I have formula in L48 & L49)
L50 to AF50 to L69 to AF69 ( I have formula in L70 & L71)
L72 to AF72 to L91 to AF91 ( I have formula in L92 & L93)
L94 to AF94 to L113 to AF113 ( I have formula in L114 & L115)
L116 to AF116 to L135 to AF135 ( I have formula in L136 & L137)
L138 to AF138 to L157 to AF157 ( I have formula in L158 & L159)
L160 to AF160 to L179 to AF179 ( I have formula in L180 & L181)
L182 to AF182 to L201 to AF201 ( I have formula in L202 & L203)
L204 to AF204 to L223 to AF223 ( I have formula in L224 & L225)
L226 to AF226 to L245 to AF245 ( I have formula in L227 & L228)...................
& so on Upto L534 to AF534 to L553 to AF553 ( I have formula in L554 & L555)

There are 20 rows in between nd after 20 rows there are two rows filled with formula, In 1st row I am getting the Black font sum total and in the 2nd row I am getting Red colored totals. then from the next row onwards 20 rows need to be copied and so on.. will be continue

in the Sheet DCBMCOPY I have data from A to V, from column B to V the data should be copied over in M sheet based on the value of C6 of M sheet

If the M sheet's C coulmn value will be find on A column of DCBMCOPY sheet then on that row the value from B to V will be copied over from L to AF on M sheet.