Hi

Not much to go on here. It is lays better to post details of your actual
question in the body of the post.

As a generalisation.
If in cells B1:M1 you had Jan, Feb ..... Dec
If in cells A2:A32 you had the numbers 1 through 31

In cell O1 you Had Jun and in cell O2 you had 5
then
=INDEX($A$1:$M$32,MATCH(O2,$A$1:$A$32,0),MATCH(O1, $B$1:$M$1,0))
would return the value that is in the cell for Jun 5th.

INDEX require 2 inputs, Row and Column.
The first MATCH finds the row number, the second MATCH finds the column
number.

--
Regards

Roger Govier


"Excel ESG" wrote in message
...

--
Shared knowledge makes you smarter