![]() Our VLOOKUP formula should now look like this: This will be a column to the right of your data where you think the answers are. So, we now need to enter a column index number. ![]() =VLOOKUP(H2,B3:F25,) – So, we have our H2, which can either hold data or be blank, and now we’ve included the range of data we want to search for duplicates, i.e. Now you should enter your table array, or lookup table, the range of data you want to search, plus a comma. =VLOOKUP(H2,) – we’ve chosen to use cell H2. This can be an actual value, or a blank cell that will hold a value, for example: You will need to enter your ‘lookup value’ between the brackets (parentheses) followed by a comma. To use VLOOKUP, simply type =VLOOKUP() in the formula bar.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |