How quickly will the following table 1 to table two forms? (if grey header table 2 list in advance, how to go from table a request for yellow part number?)
Table 1:

Table 2:

CodePudding user response:

=index (* * *, the match (* * *) that match (* * *))
Try this way, but the efficiency is too low, hundreds of lines of data update for several minutes

CodePudding user response:

Hundreds of lines of a few minutes, if not should; Can't think, however, the appearance of your data, can put a sample up to look at it?

CodePudding user response:

Didn't understand the problem