Dashboard Monthly WIH Value

[Vibro]

Hi,

I am trying to do a formula so that when I change the month on my dashboard it will return the corresponding value for that month and Job.

The number of jobs and job numbers constantly changed during the year But an example of data would be:

12 11 10 9 8 7 6
Dec Nov Oct Sep Aug Jul Jun
2892 2450 2450 2580 2690 2750
2896 100 500 1000 2500
2901 500 2500 3500 4500 6500 10000
2903 1500 3500 4000

So if I am currently in October then that value I want to return when I select October as the month (10) and I enter job number 2896 I will get 500, however if I change it to Sep (9) I then get 1000.

I did try both the following formulas but neither gives me the right answer: sumif(WIH!B:B,Dashboard!E24, Match(dashboard!P1,WIH!1:1)
but I get an error message
I also tried it with an index formula but couldn't get that to work either.

I also need to perform this so that it returns the prior month (-1) and previous month (-2) but I figure if I can get the first formula for the current month the other 2 will be easy enough as I will just have to have the Dashboard match as P1 -(minus) 1 or P1 -(minus) 2

Ta muchly.

[TMS]

You can use INDEX/MATCH/MATCH to return the results you want.

Please post a sample workbook.

[Vibro]

See attached

I did try an Index Match Match that I have previously used, however it was summing all of the values instead of just the one month that I wanted.

[Vibro]

Hi Trevor,

Thanks for the help and suggestion on Index/Match/Match

My issue was that I was constantly using the sum function. Once I took this out and just used Index it worked perfectly as I need it to do.
Also was able to get the Prior and Previous months sections to work as well by just changing the formula from $P$1 to $P$1-1 and $P$1-2.

=INDEX(WIH!$1:$1048576,MATCH(DASHBOARD!$E24,WIH!$B:$B,0),MATCH(DASHBOARD!$P$1,WIH!$1:$1,0))