Introduction to the epidemic protection material requisition form
The main content of the epidemic protection materials collection form: collection time, recipient information, name and quantity of materials received, and other related information. Huajun Software Park provides downloads of high-quality Excel templates and Excel templates for the epidemic protection materials collection form. Download the source files to get the source files for you to edit, modify and replace. The epidemic protection materials collection form template can be found in the Huajun Software Park.
General Tips for Receiving Epidemic Protection Materials
Quickly select specific columns
Select the table area, click the "Create from selected content" dialog box under the [Formula] tab, and select "First Row". After the settings are completed, open the name box in the upper left corner, and click the corresponding list to jump to the specified column.
Two column name verification
If you want to check whether the name in Table 2 appears in Table 1, a formula can be used to do it immediately.
=IF(COUNTIF(A:A,C2),"Yes","No")
it works
it works
it works