I am looking up one workbook (Figuresmaster
) to pull financial figures into another workbook (AreaBudgets
). I have the below lookup formula working (in AreaBudgets
).
=IF(ISNA( VLOOKUP($C15,'(directory_path)\[Figuresmaster.xlsx]JULY2015'!$1:$1048576,12,FALSE)), 0, VLOOKUP($C15,'(directory_path)\[Figuresmaster.xlsx]JULY2015'!$1:$1048576,12,FALSE))
I would like to now have a way of automatically finding the right month's sheet from workbook (Figuresmaster
) instead to typing it into the formulas; e.g., a replacement for July2015
in above formula).
July2015
is the sheet name. I need to be able to add sheets into Figuresmaster
and not affect the formulas.
I am hoping for a formula to direct to either the sheet name July2015
or a cell, say A1
, in each sheet.
I hope this makes sense, as I need this sheet to work.
Figuresmaster
sheet name (July2015
) into a cell inAreaBudgets
, and then have all the formulas inAreaBudgets
use it? And what are you saying about “A1 in each sheet”?=IF(ISERROR(something), 0, that_same_something)
. That can be hard to maintain (i.e., to modify, when needed, while maintaining consistency), especially if somebody else needs to take responsibility for your files. That can be simplified to=IFERROR(something, 0)
.