Contrary to popular belief, working on files online can be trouble-free. Sure, some file formats might seem too hard with which to work. But if you have the right solution, like DocHub, it's easy to tweak any file with minimum effort. DocHub is your go-to tool for tasks as simple as the option to Index Sum Object For Free a single document or something as intimidating as processing a massive stack of complex paperwork.
When considering a tool for online file editing, there are many solutions out there. However, not all of them are powerful enough to accommodate the needs of individuals requiring minimum editing capabilities or small businesses that look for more extensive set of features that enable them to collaborate within their document-based workflow. DocHub is a multi-purpose service that makes managing documents online more simplified and easier. Sign up for DocHub now!
welcome to xox trick number 714 hey if you want to download this workbook and follow along click on my youtube channel then click on my college website link it in download the workbook 711 to 7:14 and this trick here we have three criteria 1 2 3 2 of their criteria are in the actual records like this ah but the third criteria actually is a column so were doing a 3 criteria lookup and then we need to add the items so for example quad sales rep 1 California quad sales rep by 1 California is the value we want there quad sales rep 1 we want this value right there so those two values need to be added in this cell right here were going to see two methods here were going to see one that adds an extra column and joins two criteria together to create in essence a new column that will have one criteria and then well will add that extra column we use some if and the index function to say hey if its California give me the whole column of values now adding an extra column wastes Reese spreads