To me it is quite unclear what you want.

You want to retrieve data from the first workbook (SaveRefExample.xlsx I guess) based on the value in the List in cell B1. Which List. Do you mean Sheet1!B1 in Filter workbook.xlsx?

You mention something about B-Pass, HYR etc. but I do not find any of these in SaveRefExample.xlsx.

If you still want help I think you should make an effort to explain (in the file SaveRefExample) exactly what it is you want and give more examples of required results.

Good Morning XOR,

Hopefully I can explain this a little better, I apologize for the confusion.

From the beginning.. The data I am collecting is collected in The SAVRefExample Worksheet - Sheet 4. The filter workbook Sheet 1 is where I am trying to pull the data into based on the mode I am looking for. the mode is selected in cell B1, that list and all the parameters is fed from Sheet 3 of the Filter workbook. Next to each mode on Sheet 3 of the Filter Workbook is the temp I want to filter by, those temperatures are reflected in the SavRefExample workbook, sheet 4 in cell AE.

Hopefully that clears up the confusion. I appreciate the help.

Dan

Attached Files

	Filter workbook.xlsx (65.6 KB, 11 views)
	SavRefExample.xlsx (12.1 KB, 9 views)