Current location - Training Enrollment Network - Books and materials - What if the vlookup function in excel is used to find the similarity between two rows of data?
What if the vlookup function in excel is used to find the similarity between two rows of data?
Write the formula =VLOOKUP(A2, worksheet 1) in the cell (B2) next to "030389" in Figure 2. A: A, 1, 0). Suppose your drawing HS20 17 is in column A of the worksheet 1. Then drop down and fill in the formula.