VBA find match in a range

[Pierce Quality]

Hi All,
Im attempting to match a variable value in a dynamic range then fill the appropriate ranges and I am having an issue. The code below works fine when the matching values are on the same row, but the matching values can appear anywhere in the specified column, not just in the same row. In addition, blank values may occur.
Any help would be greatly appreciated, thanks!

Please Login or Register  to view this content.

[ragulduy]

Normally I would use countif for this sort of thing.

i.e.

Please Login or Register  to view this content.

would give you true if the value in C & intIndex does not exist anywhere in column T. if you change it to >0 then it gives you true if it does exist.

It's not entirely clear what you are trying to match to where with whole column references though. Hope that helps.

[Pierce Quality]

Thanks raguldy, thats definitely a step in the right direction.

When I run this:

Please Login or Register  to view this content.

The red fills in the same row of one instance of a match. I'm attempting to fill the appropriate row (range C:J for an matches in C, and range T:AA for any matches in T.

Thanks!

[Pierce Quality]

Also,

Here is an example book of representing what I am trying to accomplish.

Thanks!

[ragulduy]

Try:

Please Login or Register  to view this content.

(Assuming that T is now U in your attached example)

[Pierce Quality]

Thanks ragulguy, this works great! Is there any way to fill the same area green if heading 2 matches, but heading 4 is different like in the attached workbook?

Thanks!

Please Login or Register  to view this content.

[ragulduy]

Try:

Please Login or Register  to view this content.

[Pierce Quality]

Impressive! Thank you very much, it works great!

I have just one more question, is it possible to have the indented text thats relates to the text title fill the text area blue if heading 2 matches and the indented text does not match, like in the attached example?

Something like:

Please Login or Register  to view this content.

Thanks again!

[Pierce Quality]

Bumping along