VLookup and Nested IFs or Index Function
I have 2 spreadsheets one that is retrieving data from a database (Vlookupdata) and the second spreadsheet (Filter workbook) I want to use to retrieve data from the first workbook. I want the second workbook to retrieve data based on the value in the List in cell B1. The data in the first workbook column AE is what determines what data is retrieved. Based on the values in the List "B-Pass" for example is for all the data greater than or equal to 600, NCY is for all data between the values of 528 - 60, HYR is for the data with the values between 400 - 527, A pass is for data less than or equal to 399, and All is for all data. I am struggling to figure out how to do the Vlookup and the If statements with the ranges. If anybody can give me some help it would be greatly appreciated.
It occurs to me that the Index Function may also be a way to do this but I can't quite figure that out.
Thank you,
Dan
|