Using VLOOKUP In the formula bar , type = VLOOKUP ( ) . In parentheses, enter the search value, followed by a comma. This can be a real value or an empty cell that will keep a value: (H2,A1: B8) Enter the table matrix or search table, the data area you want to search for, and a comma: (H2, A1: B8,) Enter the column index number. This is the column where you think the answers are and should be on the right side of the search values: (H2, A1: B8,) Enter the range search value, TRUE or FALSE. TRUE finds partial matches, FALSE finds exact matches. The completed formula looks like this: = VLOOKUP (H2, A1:B8, FALSE)
Commentaires