If you want to fill in the data of the C column C column C column 1 to what should be done in Table 2

1 Answers

1. +7Votes  

   In Table 2, B2 Single Township Township Bo Laoshi input

   = iFerror (VLOOKUP ($ A2 &B $ 1, if (if (if (if (if{1,0}, Table 1! $ A $ 2: $ a $ 7 &Table 1! $ B $ 2: $ B $ 7, Table 1! $ C $ 2: $ 7), 2,), “”)

   These contents, then press the control key+upper key+return key,

   Then select the B2 unit grid right pull+fast fill.

   Explanation:

   If the data of Table 1 is shown in the figure below,

   Table 2 To get the results as shown below,This formula cannot be used.

   Dorothy- March 19, 2023 |