These parentheses will contain a set of arguments, and an argument is just a piece of data that the function needs in order to run. ![]() ![]() To do that, I'll click the cell where I want to see the Prices, I'll enter an = sign, VLOOKUP, and parentheses. So, as an example, I'll enter part numbers, the thing I know, and find out Prices, the thing I don't know. VLOOKUP works a lot like a phone book, where you start with the piece of data you know, like someone's name, in order to find out what you don't know, like their phone number. ![]() When you need to find information in a large spreadsheet, or you are always looking for the same kind of information, use the VLOOKUP function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |