Hi, could someone help me with a formula?
I'm trying to return the values in C4:F4 if H5:J5 is equal to C5:F5....see example below
So H4 would be equal to "Q1", I4 would be equal to "Q2", and J4 would be equal to "Q3" and I would be able to autofill. Thank you very much for help in advance.
I'm trying to return the values in C4:F4 if H5:J5 is equal to C5:F5....see example below
So H4 would be equal to "Q1", I4 would be equal to "Q2", and J4 would be equal to "Q3" and I would be able to autofill. Thank you very much for help in advance.