I ask a simple question EXCEL master urgent! ! ! ! ! ! ! ! !

Users questions: According to Table 2, Table I appended to the A, B and C in the corresponding column is urgent thank you! ! ! ! ! ! ! ! ! Table ABC1IKIJ2ILIG3INIM4IDIS Table II A13456 Jia! ! ! Table is too large to upload to help QQ42132573 Thank you I know Road use this but there are still many out there to find not added a QQ I give you my pass too can not upload
Experts answer: Table II column B the formula: = VLOOKUP (A1, Table! A: B, 2,) Table two column C the formula = VLOOKUP (A1, Table! A: C, 3,)
  • This information provided by the users.Thanks!