Hi,
I have a simple table that has 3 years on the horizontal, and 5 months on the vertical.
I want to return values from the table for a specified month and year. What I need is a formula.
Attached is the file.
Many thanks in advance.
Hi,
I have a simple table that has 3 years on the horizontal, and 5 months on the vertical.
I want to return values from the table for a specified month and year. What I need is a formula.
Attached is the file.
Many thanks in advance.
BC,
Try this formula in the lookup cell
=OFFSET(C2,MATCH(H20,C3:C7,1),MATCH(E20,D2:F2,1),1,1)
HTH
Jason
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks