V lookup in sheet summary

jtlsf1

Is there a limit to the number of V lookup reference sheets I can use on a sheet's summary tab? It seems like when I change a field to reference 'Sheet A,' and save, the other fields also change to 'Sheet A' even though I indicated 'Sheet B' for that field.

Ezra

Sometimes I've caught myself using the same {RangeName} for lookups and other formula. When in doubt, remove the range from the formula and click on the "Reference Another Sheet" from the formula hover-tip window.

As a general practice I try to be fairly specific with my range names, like: {Range_Name_Start} or {Range_Name_End}