Vlookup + cell color function

[astir]

Hi,

I have now used couple of days trying to find and combine others macros without luck to getting this work so hope somebody could help me with this...

Scenario is that i have in one table a "master" devices having a value and color.
master table looks like:
a12=device_name1, c12=text&color, d12=text&color...etc
a13=device_name2, c13=text&color, d13=text&color...etc

*colors are varying much*

and then I have "child" devices where I would like to get same values and color settings automatically than what "master" device have.
child table looks like:
a146=name_of_child, b146=name_of_master, c146=****cell value and color from master device from same column, triggered from b146****
second row like above

I have found a way to change value but not the color:
**in cell C146**=VLOOKUP($B146;$A$12:$E$38;COLUMN(C12))

maybe best would be a function where I can give those same attributes but it also would change the color.

Thank you really much if you can help!!!
-Astir

 

[al_b_cnu]

Hi Astir,

Not too sure what you require here :¬(

Can you post an example, and also a description of the error?

 

[astir]

Hi,

i was jus thinking some code that didnt care if the key name in column C is missing.

But I can use some dummy names so this is not the case and you dont have to use your time for this

I can go with this perfectly now, thanks
-Astir