I have a file with dates in column A running from Rows 4:260 and the 50 states as columns in Row 2 across columns B:BA
I am trying to pull data for dates in a different table:
In Cell B266 I put in the formula =INDEX($A$2:$BA$260,MATCH($A266,$A$4:$A$260,0),MATCH($B$265,$B$2:$BA$2,0))
but I am not getting it to return $2.22 which is what I want...I can't even figure out where the number it is pulling is coming from.
What am I doing wrong here?
Thanks for the help!
ROW 2 | Alabama | Arizona... | Wyoming |
ROW 4, COLUMN A January 2001 | |||
.... | |||
(A260) May 2022 | $2.22 | $2.54 | $4.64 |
I am trying to pull data for dates in a different table:
Cell A266 = May 2022 |
Cell B265 = Alabama |
In Cell B266 I put in the formula =INDEX($A$2:$BA$260,MATCH($A266,$A$4:$A$260,0),MATCH($B$265,$B$2:$BA$2,0))
but I am not getting it to return $2.22 which is what I want...I can't even figure out where the number it is pulling is coming from.
What am I doing wrong here?
Thanks for the help!