Thread: [Solved] VLookup and Nested IFs or Index Function
View Single Post
 
Old 04-07-2016, 09:45 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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.
Reply With Quote