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)