R
rucker31
Is it possible to have multiple (or at least 2) lookup value’s where the
lookup vector would be spread across multiple spreadsheets. Hypothetical
formula: =lookup(D1,D2,'Sheet1:Sheet9'!A2,'Sheet1:Sheet9'!A4)….or put another
way:
D1=the appropriate worksheet and D2=the vector within that sheet. Pardon the
rookie question but any input would be greatly appreciated.
lookup vector would be spread across multiple spreadsheets. Hypothetical
formula: =lookup(D1,D2,'Sheet1:Sheet9'!A2,'Sheet1:Sheet9'!A4)….or put another
way:
D1=the appropriate worksheet and D2=the vector within that sheet. Pardon the
rookie question but any input would be greatly appreciated.