VBlookup with multiple nested IF statements

[SavGDK]

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.

I have the spreadsheets but I don't see a why to attach them.

Thank you,

Dan

 

[SavGDK]

It occurs to me that a VLookup may not be the correct tool, I want to return all the data in the array except for the values that specified below. So if my choice is HYR, and there are 75, rows of data in 20 columns that fit this criteria, I want to return all of that information. Suggestions?

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.

I have the spreadsheets but I don't see a why to attach them.

Thank you,

Dan