When you want to apply a minor tweak to the document, it should not require much time to Index spreadsheet deed. This type of simple action does not have to require additional education or running through guides to learn it. With the appropriate document modifying instrument, you will not take more time than is needed for such a swift change. Use DocHub to simplify your modifying process whether you are an experienced user or if it is your first time making use of a web-based editor service. This instrument will require minutes or so to learn to Index spreadsheet deed. The only thing needed to get more productive with editing is actually a DocHub account.
A simple document editor like DocHub can help you optimize the amount of time you need to devote to document modifying regardless of your previous experience with this kind of instruments. Make an account now and increase your productivity instantly with DocHub!
okay so in this video Im going to cover index and match functions and it might be a single video or multiple videos if you see something like part one in the video title then there are multiple videos because there could be quite a bit of content here what index and match functions do well were gonna start by match function and well see what that does and well do one right so what Ill do Ill go ahead and grab one of these stock numbers place it over here lets give this an appropriate label so Im gonna paste this here too now lets use our match function so to use the match function Im gonna do it here Im gonna start equals match and there this tab should fill that in so the first thing in this function is the search key search key is going to be the stock number so in this particular case oops should have been be 15 this one comma and the range is going to be this range of stock numbers Im not including the label in there by the way so Im going to lock that range with f4 k