Index and Match

[Steved]

Hello from Steved
If I copy the below formula down to the next cell I want
it give me the value of the second row in Column C.

=INDEX($A$1:$C$217,MATCH
($E$4&$E$3,$A$1:$A$217&$B$1:$B$217,0),3)

Thankyou.

 

[Frank Kabel]

Hi Steved
not really sure what your expected result would be as you
are using a MATCH function?

 

[Steved]

Hello Frank

=INDEX($A$1:$C$217,MATCH
$E$4&$E$3,$A$1:$A$217&$B$1:$B$217,0),3)

Below Function you will see +5 would it be possible to
include it in the above formula.

=INDEX(B$1:$C$217,SMALL(IF(B$1:$B$217=$I$3,ROW
($B$1:$B$217)-ROW($B$1)+5,ROW($B$217)+5), $D$5),2)

Thankyou.

 

[Frank Kabel]

Hi Steved
I'm sure for you it's easy to understand what you're
trying to do but for me it's not that clear
- What do you want to combine
- what do you want to get as a result

Try the following:
- post some example rows of your soruce data (plain text9
- describe in plain text what the result should be
(describe your conditions and the expected result based on
your example data)

 

[Steved]

Hello Frank

Col A is Date for the Month
Col B is =TEXT(A1 "ddd")for the day
Col C is Data

Below is Date in this case being the month of April
Col E3 is , Col F3 , Col G3 , H3 , I3 1, J3 2 and K3 3

Below is WeekDay
Col E3 is Sun, Col F3 Mon, Col G3 Tue, H3 Wed, I3 Thu, J3
Fri and K3 Sat Col E4

Each day I receive 7 Data Values which *month=217 rows.

Below is what I want the Formula to do is put the data
from Col C to Col I3,39671 I4,36452, I5,7821 I6,27385 and
so on going on The date When I change Colum A to May the
first day will be Sat 1 June will be Tue and so on.

Simple put The formula will put the data under the
appropite column for that month. I have only put the first
day in What I will do is I will use the formula to
populate the rest of the month.

I have in Column E1 is =TEXT(E2 "ddd")
I have in Column E2 is a formula which creates the month
A B C
1-Apr Thu 39671
1-Apr Thu 36452
1-Apr Thu 7821
1-Apr Thu 27385
1-Apr Thu 21781
1-Apr Thu 5041
1-Apr Thu 19818

Thankyou.