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)
|