People frequently need to revise look in excel when working with documents. Unfortunately, few applications provide the tools you need to complete this task. To do something like this typically requires alternating between multiple software programs, which take time and effort. Fortunately, there is a service that works for almost any job: DocHub.
DocHub is a professionally-built PDF editor with a full set of helpful functions in one place. Altering, signing, and sharing forms is easy with our online solution, which you can use from any internet-connected device.
By following these five easy steps, you'll have your revised excel quickly. The intuitive interface makes the process fast and productive - stopping switching between windows. Try DocHub now!
welcome to Exel magic trick number 149 hey if you want to download this workbook and follow along click on my YouTube channel then click on my college website link and download the workbook XL magic trick 146 to 154 hey trick 149 weamp;#39;re going to do a reverse two-way lookup and this video is in response to some earlier videos I made Excel magic trick 117 and 118 in these videos we had d duplicates so we did reverse two-way lookup with duplicates so in 149 here Iamp;#39;m going to show you how to do a much easier formula when you donamp;#39;t have duplicates then in trick 149.5 weamp;#39;ll deal with a problem that arose uh from 118 okay so letamp;#39;s go down here and hereamp;#39;s the situation we want to do a reverse two-way lookup and what that means is you take the number 409 and you look through the guts of the table and you either want to return so for 409 the column would be Oregon or the row would be Product 2 now letamp;#39;s do our formula and weamp;#39;ll use u
