View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Vlookup where range changes

Add headers to your data and remove spaces to get this:
Bin Lot
Filter1
Category1 11
Category2 12
Category3 13
Category4 14

Filter2
Category1 21
Category2 22
Category3 23
Category4 24

Filter3
Category1 31
Category2 32
Category3 33
Category4 34

Filt
2
Caty
1
Result
21

Select the array from Bin to 34 and
Insert Name Create Top Row
Name Filt and Caty in the same way.
The 2 and 1 are the desired Filter and Category numbers.
Enter this formula in Results:
=INDEX(Lot,MATCH("Filter"&Filt,Bin,0)+Caty)