matrix lookup

Hello, this is my first thread but I have been reading and learning since months if not years. Now I'm stuck with this problem and I can't find a solution on my own. I have a binary table like this: <tbody> A B C D 16C 0 1 0 0 51C 0 0 1 0 17A 0 0 0 1 39A 0 1 0 0 24C 0 0 0 1 16A...

Hi, I have two tables of data that I'm trying to sort into a matrix, were I'm currently using an index/match array function for each separate cell, which work, but the matrix has 90.000 cells, so the sheet takes 25min to calculate - not optimal. The sheet looks like the picture below. Using...

So I have this table that looks like this in a sheet called Raw Data: <tbody> A B C D E ... SF 1 Date 1 Date 2 Date 3 Date 4 Date 5 Date ... Date 500 2 Other Other Other Other Other Other Other 3 125487 245875 325665 125452 547854 325658 399856 4 302154 125475 245478 326585 214523...

Table, sumif for index(match())Gentleman, I've tried other topics and matrix lookup with sumif but didnt find a solution for my case, some one have a glue on how to do that? Table 1 Product State Condition Discount Price 1 Price 2 Price 3 Car 1 TX Used 1% 4362 5962 4737 Car 1 TX Used 2% 4123...