J
Joe
When inputting the table_array information in a Vlookup formula you can
either input a range of cells or named range.
My named range changes monthly so I tried to use a cell reference in the
Vlookup formula to capture the new named range but the formula returns N/A#
error?
i.e. cell A1 "Mth_1"
formula: =Vlookup("Sales",A1,2,false)
The formula works is if the named range "Mth_1" is included as part of the
formula instead of reference to a cell that contains the name of the range to
lookup.
Any suggestions? I am trying to make the update process quicker than
performing a fine and replace on multiple tabs.
Thanks
either input a range of cells or named range.
My named range changes monthly so I tried to use a cell reference in the
Vlookup formula to capture the new named range but the formula returns N/A#
error?
i.e. cell A1 "Mth_1"
formula: =Vlookup("Sales",A1,2,false)
The formula works is if the named range "Mth_1" is included as part of the
formula instead of reference to a cell that contains the name of the range to
lookup.
Any suggestions? I am trying to make the update process quicker than
performing a fine and replace on multiple tabs.
Thanks