If you want to apply a minor tweak to the document, it must not take long to Index conditional field record. Such a simple activity does not have to demand additional training or running through handbooks to understand it. With the appropriate document editing instrument, you will not spend more time than is needed for such a quick change. Use DocHub to simplify your editing process regardless if you are an experienced user or if it is the first time making use of an online editor service. This instrument will require minutes or so to learn to Index conditional field record. The sole thing required to get more effective with editing is actually a DocHub profile.
A simple document editor like DocHub will help you optimize the amount of time you need to dedicate to document editing no matter your prior knowledge of such instruments. Make an account now and enhance your efficiency immediately with DocHub!
so we already learned about vlookups and index matches but the problem with these functions is that they only allow us to match up single values but what if we had to do lookups based on multiple criteria for instance in this example which is in the index match array file and I provided a link to these files in the video description if you want to follow along we have three different fields and each of these fields contain different information related to smartphones in column a we have the model okay so its either an iPhone or a galaxy and column B we have the version so you have the version 9 the X the X are the galaxy 9 or the galaxy 10 and in column C we have the storage now suppose here in so H 8 we wanted to find the quantity available and then cell h 9 we wanted to find the cost for a particular type of phone based on the values in cells h 3 through age 5 well in order to do that were gonna have to use whats called an array if we try to do a vlookup or an index match its no