Index Match Function Help

Shwets

New Member
Joined
Jul 6, 2009
Messages
2
Hi,
I need to have an INDEX MATCH function return a value AND FORMATTING (color coded numerical values).

I have been looking everywhere and cannot find any help on how to retrieve/match formatting from one set of data to another.

Any ideas? THANK YOU!!!:eek::confused:
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Shwets

New Member
Joined
Jul 6, 2009
Messages
2
Thank you, Aladin.

Is there anything I can do? Would a macro be able to do that for me?
And if so is there anywhere, that you could mention, I could look up one (ie. macro reference database?), or will I have to attempt to write it (I haven't done so since a basic course in college)?

Thank again!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,176
Messages
5,600,140
Members
414,365
Latest member
UUR

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top