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.