/ jzcmailprofit39's Library/ Notes/ 1. Organize the information source. Here we demonstrate the production in the employee information and facts query window. Frequently, there's an employee information and facts table around the personnel. We are able to use it directly. The most vital ste
1. Organize the information source. Here we demonstrate the production in the employee information and facts query window. Frequently, there's an employee information and facts table around the personnel. We are able to use it directly. The most vital ste
from web site
How can we promptly put the photo corresponding to every single person in the appropriate spot? You may refer to this video I wrote just before
Batch insert pictures with corresponding names
Second, set the query table format, set the drop-down menu mainly because the query requirements are extremely various, we need to set the format of the query table as outlined by our actual specifications, simply because here we demonstrate the creation of the employee info query window, so we use the job number because the search value To seek out everyone's information. Applying the job number because the search value should be to stay clear of duplication on the search value. Similarly, to be able to steer clear of getting into the incorrect job number and not obtaining the right information, we set a drop-down menu for the cell of the job number to prevent entering the incorrect job. No., initially click the information function group, then find the information verification, pick the sequence in the permission, and after that select all the job numbers in the information table and click OK, then the drop-down menu is completed
three. Use vlookup to query the information. When the format and drop-down settings are completed, we are able to make use of the vlookup function to reference the data in the data source for the query table inside the corresponding cell. In fact, it truly is the typical usage from the vlookup function. We use the lookup quantity to correspond 'S name tells you how to come across it. canon cf card file missing , we choose a job number, and after that enter the function = VLOOKUP (B2, data source! A: B, two,0) inside the name cell, then click Enter Uncover the name corresponding to this job number, and so on, the orange a part of the table will need to use the vlookup function to discover so
Fourth, discover the corresponding photographs of staff When we use vlookup to reference each of the information in to the query table, we need to have to begin generating the effect of query photographs. Here we use the index plus match function to achieve this effect. Initial We enter the function in the blank spot to find the image
= INDEX (Information source! $ C: $ C, MATCH (Sheet1! $ B $ 2, Data supply! $ A: $ A, 0)) You'll be able to see that the function result is 0 at this time, due to the fact we are looking for photos, So the result is 0, subsequent we will need to assign the function for the picture
Very first we copy this formula, then click the formula function group to discover the definition name, we set the name to tx, and then paste the copied formula into the reference position, click OK
Then we copy any picture for the place with the photo, click on this image, and then enter an equal sign within the edit bar, then enter the name we just defined is tx, click Enter, then the production is total, when we You may find the corresponding info and photos by altering the drop-down menu, plus the facts query window is now full
how about it? Have disappeared canon cf card file missing learnt that?
I'm excel from zero to a single, comply with me and continue to share a lot more excel tips
Batch insert pictures with corresponding names
Second, set the query table format, set the drop-down menu mainly because the query requirements are extremely various, we need to set the format of the query table as outlined by our actual specifications, simply because here we demonstrate the creation of the employee info query window, so we use the job number because the search value To seek out everyone's information. Applying the job number because the search value should be to stay clear of duplication on the search value. Similarly, to be able to steer clear of getting into the incorrect job number and not obtaining the right information, we set a drop-down menu for the cell of the job number to prevent entering the incorrect job. No., initially click the information function group, then find the information verification, pick the sequence in the permission, and after that select all the job numbers in the information table and click OK, then the drop-down menu is completed
three. Use vlookup to query the information. When the format and drop-down settings are completed, we are able to make use of the vlookup function to reference the data in the data source for the query table inside the corresponding cell. In fact, it truly is the typical usage from the vlookup function. We use the lookup quantity to correspond 'S name tells you how to come across it. canon cf card file missing , we choose a job number, and after that enter the function = VLOOKUP (B2, data source! A: B, two,0) inside the name cell, then click Enter Uncover the name corresponding to this job number, and so on, the orange a part of the table will need to use the vlookup function to discover so
Fourth, discover the corresponding photographs of staff When we use vlookup to reference each of the information in to the query table, we need to have to begin generating the effect of query photographs. Here we use the index plus match function to achieve this effect. Initial We enter the function in the blank spot to find the image
= INDEX (Information source! $ C: $ C, MATCH (Sheet1! $ B $ 2, Data supply! $ A: $ A, 0)) You'll be able to see that the function result is 0 at this time, due to the fact we are looking for photos, So the result is 0, subsequent we will need to assign the function for the picture
Very first we copy this formula, then click the formula function group to discover the definition name, we set the name to tx, and then paste the copied formula into the reference position, click OK
Then we copy any picture for the place with the photo, click on this image, and then enter an equal sign within the edit bar, then enter the name we just defined is tx, click Enter, then the production is total, when we You may find the corresponding info and photos by altering the drop-down menu, plus the facts query window is now full
how about it? Have disappeared canon cf card file missing learnt that?
I'm excel from zero to a single, comply with me and continue to share a lot more excel tips
