Macro that finds value given 3 conditions

I need help creating a macro that finds a value given 3 conditions, year, quarter and color. I realize that the easiest way to solve this is by creating a pivot table, but I was asked to solve this using a macro.

Here is what the table looks like, I need to be able to find the value in C12 given the conditions around it.


I appreciate your time and any advice would be pleasantly taken.

1 answer

  • answered 2018-10-16 07:12 Pᴇʜ

    You can use the following formula for the worksheet in your question.