VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

**chintu94** · 08-29-2020, 05:56 PM

Hi folks,

I have a unique requirement, attached is the spreadsheet where I have column A, B and C with the data

I already have formula to vlookup/ match the source and put it across the rows as you can see in the attached sheet. Column D is the look up value and column E to G i have the results displaying in row from the column B.

Question: I want to use column C in a way that if there is a month Jan in that column, the corresponding fruit in the Results (Column E to G) should highlight in Green color. so for example for the Banana fruit the month is Jan and it should highlight in the results row whereever it is Banana in Green color. How do I put that conditional formatting?

Thanks

Chintu

**protonLeah** · 08-29-2020, 07:19 PM

Month dropdown in C1.
cond format with:

Please Login or Register  to view this content.

**wk9128** · 08-29-2020, 07:47 PM

Please see the attached conditional formatting formula

**AliGW** · 08-30-2020, 02:28 AM

Sorry for off-topic interjection:

Once again, wk9128, although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

**chintu94** · 08-30-2020, 03:23 PM

Thank you wk9128 appreciate your help

Is it possible to combine your match table to not look at ONLY Fruit Column, but also the Name column?

Thanks

**wk9128** · 08-31-2020, 04:25 AM

Moderator, I am in the right direction. I am busy at work and take the time to answer. I only owe a name to it. Is it so serious? Just add it, please refer to this attachment.

**AliGW** · 08-31-2020, 05:13 AM

If you are busy at work, then you probably shouldn't be posting here, anyway, and you are completely missing the point of the request. Some members are not able to download attachments, so your answers, for them now and in years to come, are inaccessible.

Please co-operate with this request in future, for the benefit of all our members. Thanks.

For the benefit of all, here is the CSE (array) formula suggested in the attachment above:

=IFERROR(INDEX($B$3:$B$13, SMALL(IF($D3=$A$3:$A$13, ROW($B$3:$B$13)-2,""), COLUMN()-4)),"")

**chintu94** · 08-31-2020, 10:21 AM

Hi AligW

The formula that you mention is straight copy paste of my formula from my excel attachment, that is not what i asked..

I think i got what wk9128 provided in his excel as conditional formatting

Thanks for your response appreciate

Regards

chintu

**wk9128** · 09-01-2020, 10:20 PM

#06 There is a conditional formatting formula I wrote, I copied one, Formula is =COUNTIFS($A:$A,$D3,$B:$B,E3,$C:$C,$C$5) Color choice green

Other practices and so on.......

VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

LinkBack

Thread Tools

Rate This Thread

Display

VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

Re: VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

Re: VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

Re: VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

Re: VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

Re: VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

Re: VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

Re: VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

Re: VLOOKUP return multiple matching ROWS and Condition Format based on 3rd Criteria

Thread Information

Users Browsing this Thread

Similar Threads

Return multiple matching values based on one criteria

[SOLVED] Objective: delete rows based on multiple criteria matching

Vlookup based on matching multiple rows

Combine multiple rows in a specific column based on matching criteria? VBA solution?

copy rows from multiple worksheets to a new condition based on criteria

[SOLVED] Mark or Delete Rows based on Matching Multiple Criteria in another worksheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions