How to name cells automatically using top row and left column entries

Hello. Say I have Jan, Feb, Mar going across the top row of my table, and Revenue and COGS going down the left column of my table. Is there a way to automatically name the corresponding interior cells Jan.Revenue, Feb.Revenue, etc. without using VBA? Highlighting the entire table and using the Insert - Name - Create (and then selecting the "Top Row" and "Left Column" boxes), I am able to name the ranges, but I would like to be able to name the individual cells. Not looking for the VBA code at this time . . . just if it can be done without using VBA. This seems like a task that Excel can easily do, but can't seem to find the feature. Thank you.

This sounds like a job for dynamic named ranges.

See them at
http://www.myonlinetraininghub.com/e...c-named-ranges or
http://www.bettersolutions.com/excel...G820716330.htm

Hi, welcome to the forum

To name a range of "ranges" in 1 go is fairly easy (Not sure how you would get the additional text in the range name if its not in the heading though)

Highlight the range - including the headings
Formula tab/Defined Names/Create from selection
check Top Row, if its not already selected

OK then maybe instead of using names ranges, you could use INDEX/MATCH to bring back the value of the intersect?

As long as you got what you need, but keep in mind there are probably functions for this that you are unaware of, that will make things a lot simpler for you

Looking forward to helping you again

hmm actually, just for the heck of it, can you uplad a small (clean) sample of your workbook, showing what you are working with and what you want?

Thanks.

Just as an example, assuming your data looks like this...

	A	B	C	D
1		Jan	Feb	Mar
2	Revenue	50	500	5000
3	Cost	30	300	3000
4	Gross Profit	20	200	2000
5
6	Feb	300
7	Cost

with A6 and A7 being your 2 variable criteria...
B6=INDEX($B$2:$D$4,MATCH($A$7,$A$2:$A$4,0),MATCH(A6,$B$1:$D$1,0))
After you have copied that formula, try changing 1 or both of A6 and A7, to see how it pulls in different values, depending on youyr selection.

For your real data, you would probably have to change the ranges I used

Now, we can get even fancier by adding drop-down menues to A6 and A7, to avoid typos and make selections easier. If this is something that would interst you, let me know and I can help you set that up too

Happy to help and thanks for the feedback