Result of two formulas (vlookup and Color) into one CELL

Hi,

I have a situation where -

a. I have an array that need to be searched using vlookup say A1 thru B30, using elements of C1 thru C30.
b. The second column of the array i.e. B1 thru B30 need to be displayed in D1 thru D30 (if found).

The above part can be easily done using vlookup alone.

However, few of the items in A1 thru B30 are highlighted using RED color, and I need this color in D column.

For E.g. If C1 is found at location A20 (which is of RED color), I need D1 to -

a. Display value of B1 in D1.
b. D1 cell should be RED in color.

I believe, VBA need to be made use of to write a UDT for retrieving the cell color, and the same invoked in the sheet.

However, how can the result of both be set in a single cell?

Regards,
CT

Hi
See the attached workbook.
Colour code is arrived using GET.CELL function.
then conditional formating is done using the colour code returned

only red colour will work in the attached file,

thanks
Sadath

Hi Sadath,

Thanks a lot for the help. However, could you please explain a bit more on linking the two sides -

I see that you have used =COLOUR=3 and =COLOUR=2 in conditional formatting. How is this linked to the colour of cell in A column. Where have you specified GET.CELL?

I can see a CVLookup function coded in VBA. However, it doesn't seem to belong here.

Regards,
CT.

I got it!!!

You have added the "COLOUR" as a name in Name Manager. Very nice!