I'm doing a vlookup across multiple tabs and I have one summary sheet.
All of the lookup values are listed on the summary tab along with their tab
designation (ie A1 = Doe, John, A2 = MW Region).
Would it be possible to do a vlookup in this summary tab using these
references? For example, would it be possible to do vlookup(A1,
A2!$A$23:$D$320,4,false)
I want to be able to have the vlookup search in the right tab without having
to change the formula for each section.
Thank you!