1. Organize the information source. Here we demonstrate the production from the employee facts query

How can we rapidly place the photo corresponding to each particular person within the suitable place? data recovery software can refer to this video I wrote ahead of

Batch insert images with corresponding names

Second, set the query table format, set the drop-down menu because the query requirements are extremely distinct, we need to have to set the format in the query table according to our actual requirements, simply because here we demonstrate the creation on the employee facts query window, so we make use of the job quantity as the search value To discover everyone's data. Applying the job number as the search value is always to prevent duplication of your search value. Similarly, in file recovery software to steer clear of getting into the incorrect job number and not acquiring the correct data, we set a drop-down menu for the cell on the job number to prevent getting into the wrong job. No., initially click the data function group, then uncover the data verification, choose the sequence within the permission, and after that choose all of the job numbers inside the information table and click OK, then the drop-down menu is completed

three. Use hard drive recovery software to query the data. When the format and drop-down settings are completed, we can make use of the vlookup function to reference the data in the data supply towards the query table inside the corresponding cell. Actually, it truly is the typical usage with the vlookup function. We make use of the lookup quantity to correspond 'S name tells you how you can locate it. First, we choose a job quantity, after which enter the function = VLOOKUP (B2, information source! A: B, 2,0) inside the name cell, and then click Enter Obtain the name corresponding to this job quantity, and so on, the orange part of the table will need to utilize the vlookup function to locate so

Fourth, obtain the corresponding images of personnel When we use vlookup to reference all the data in to the query table, we need to have to begin creating the impact of query pictures. Here we use the index plus match function to achieve this effect. Very first We enter the function inside the blank location to discover the image

= INDEX (Information supply! $ C: $ C, MATCH (Sheet1! $ B $ best data recovery software , Information source! $ A: $ A, 0)) You are able to see that the function outcome is 0 at this time, mainly because we're seeking for photographs, So the result is 0, subsequent we need to have to assign the function to the image

Initial we copy this formula, then click the formula function group to discover the definition name, we set the name to tx, after which paste the copied formula in to the reference position, click OK

Then we copy any picture for the place in the photo, click on this image, then enter an equal sign within the edit bar, then enter the name we just defined is tx, click Enter, then the production is complete, when we You are able to locate the corresponding information and facts and photos by altering the drop-down menu, and the information query window is now total

how about it? Have you learnt that?

hard drive recovery software am excel from zero to a single, follow me and continue to share extra excel tips