Using names in a formula

J

John Pugh

Hi,

I used Excel a lot some years ago and now need to use it again (Excel2000)
and can't figure out how to do something that was really useful.

The situation:
'Budget' worksheet has month names in the top row and account numbers in the
left column.
I have selected all cells and Created Names with TopRow and Left Column
selected.

'Reports' worksheet has month names in the top row and account names in the
left column, but not necessarily in the same relative position as in the
Budget worksheet.

A formula such as =May Bank_Charges (where May and Bank_Charges are names)
returns the correct result, but I don't want to type the formula in every
relevant cell.

I want to enter a formula in the Reports worksheet that looks up the text
in the top row and left column and substitutes the names so I can enter the
formula in one cell and paste it to other cells.

Thanks in advance,

John Pugh
Adelaide, South Austraila
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
MACRO - Copy several non contiguous cells. ~90% there... 0
COUNTIFS with No Criteria 1
Changing column reference for number of formulas at once 1
Possible to select a string in a locked cell? 1
Table Preferred width is changed when pasting 1
Find Duplicate names listed in opposite order 1
list items from one table in another table based on value in first table 2

Top