Urgent assignment in excel for 1 hour of work
Employer
[no-member:pro]Matvey[/no-member:pro]Matvey
Project parameters
Type of cooperationOne-time project
SectionOther / Miscellaneous
Prepaymentprepayment is possible
Payment methodsBank transfer
Acceptance of requestsclosed
Project description
For tables on the pages of Disassembly and Base of Pharmacies, install filters and fix the top line.
For each client on the Discussion page, find a match on the Pharmacy Database page, then copy Pharmacy ID, MD Pharm. Chain ID, MD Pharm.Chain Name of the necessary institution from the page of the Pharmacy Base and put in the appropriate column on the page Discussion. If there are comments on the found data - fill in the appropriate column Comments on the tab Discussion.
Add information on the availability of a contract with the network (Yes or NO). *In this task, it is recommended to use the VDP function (VLOOKUP). When using formulas, do not keep formulas as values.
For each client on the Discussion page, find a match on the Pharmacy Database page, then copy Pharmacy ID, MD Pharm. Chain ID, MD Pharm.Chain Name of the necessary institution from the page of the Pharmacy Base and put in the appropriate column on the page Discussion. If there are comments on the found data - fill in the appropriate column Comments on the tab Discussion.
Add information on the availability of a contract with the network (Yes or NO). *In this task, it is recommended to use the VDP function (VLOOKUP). When using formulas, do not keep formulas as values.
