I have titles in B12 to B47 vertically
And the same titles list in C11 to AL11 horizontally
I have a table of values between these 2 axes, Range C12:AL47
In C49 and C50 I have a drop down list (validation kind, not form) where the 2 Titles can be chosen.
In C51 I want to "source" the cell (i.e. the value) in the table where these 2 titles Meet.
To be Clear:
C49 is the Horizontal axis reference
C50 is the vertical axis reference
Help?
And the same titles list in C11 to AL11 horizontally
I have a table of values between these 2 axes, Range C12:AL47
In C49 and C50 I have a drop down list (validation kind, not form) where the 2 Titles can be chosen.
In C51 I want to "source" the cell (i.e. the value) in the table where these 2 titles Meet.
To be Clear:
C49 is the Horizontal axis reference
C50 is the vertical axis reference
Help?