T
The Great Attractor
Instead of pointing to a specific sheet and data range for the second
VLOOKUP particular, I found that if one merely highlights the data range
in the "lookup sheet", then enters a name for that data range in the
upper left corner of the sheet while it is highlighted, then all that
"sheetname!A:B" etc. stuff can be replaced simply by the new tagname you
gave to that data range highlighted selection as in the example:
Lookup cell is: A1 (replace with your cell)
Tagged range name is: looktable (replace with your tag name)
grabbed data column is: 3 (replace with your data column number)
so:
VLOOKUP (A1,looktable,3,FALSE)
no more bangs or cell range calls!
This would be for fixed range selections given a tag name. If your
lookup table continually expands, you'll have to expand the range given
to the tag name, or tag it each time before applying the lookup. (I
think)
VLOOKUP particular, I found that if one merely highlights the data range
in the "lookup sheet", then enters a name for that data range in the
upper left corner of the sheet while it is highlighted, then all that
"sheetname!A:B" etc. stuff can be replaced simply by the new tagname you
gave to that data range highlighted selection as in the example:
Lookup cell is: A1 (replace with your cell)
Tagged range name is: looktable (replace with your tag name)
grabbed data column is: 3 (replace with your data column number)
so:
VLOOKUP (A1,looktable,3,FALSE)
no more bangs or cell range calls!
This would be for fixed range selections given a tag name. If your
lookup table continually expands, you'll have to expand the range given
to the tag name, or tag it each time before applying the lookup. (I
think)