Forum Discussion
janaki223
Aug 14, 2019Copper Contributor
EXTENDING A NAMED RANGE
I have a range of cells in a sheet that is named, and formulas in a different sheet refer to that range. I inserted a row into the middle of that range (had an entry to add), and now one row at t...
janaki223
Aug 14, 2019Copper Contributor
would this work in a vlookup formula? that's the most common reason I create ranges.
so, using your example, if I want to lookup an amount on a given date, could I use this:
=vlookup(A2,Source,4,FALSE)
??
nabilmourad
Aug 14, 2019MVP