I've attached a sample workbook which contains 3 sheets.
The first sheet is the "Analysis" sheet which looks up data in the other sheets. (The actual workbook I'm using has over 50 sheets).
In this sample workbook, I've named two ranges. The range names are the same as the sheets, concatenated with an "R". So the range I'm using in the AAVE sheet is named AAVER.
I am able to pull up data for single cells in the two ranges using VLOOKUP and INDIRECT. (See columns J:N of the Analysis sheet).
However I want to also obtain the MIN of a range of data in each of the two sheets, also using some kind of lookup formula. (or possibly LAMBDA?).
Any suggestions on how to accomplish this? I appreciate your help!
Bookmarks